version compatibility

My spreadsheet was created in Excel 2007. There are data validations in a few places, all referring to named ranges on another sheet in the same workbook. The drop-down arrows are missing only for one user, who has Excel 2010. Other users have 2007, 2010, or 2013. The dropdowns were working...

HI, into below code I'm set up pivot version depon on Excel version. Do you know what is pivot Table version for excel 2016? Function pivotTableVersion() On Error Resume Next Select Case Application.Version Case "9.0" pivotTableVersion = 0 'excel 2000 Case "10.0" pivotTableVersion...

Just as the title says - the radio buttons cannot be selected, and the user also can't right click on them. I struggled to find someone else who had the same problem, but we followed the steps in these two posts and it did not fix it: unable to click ActiveX control and form control Excel 2010...

I have a document created in Excel 2010 with data validation throughout the document. When I open it in 2007 the validation is lost. Is there a work around or is this a known issue with none? TY Ann

I hope someone can help. I have a rather extensive VBA "program" that runs fine in Excel 2000 and 2010. But when run using all the same components, Excel 2013 hangs and needs to be cancelled by Task Manager. The one time that I did get it to run, I set breakpoints at different points in the...