compatibility issue

Hello, Given you don't need anymore in 365 to use to work with array formulae and functions... what happens when somebody with Excel 2010 opens a spreadsheet created in 365, in which the formulae weren't originally entered with Control + Shift +Enter (and presumably don't have the curly...

Hi all, I have a workbook that when sent from an apple computer back to me on desktop version lost all functionality of the command button. My aim is to try restore the original functionality of this button. All the code is still in the original sheet code but the button no longer links to it...

Hi everyone, I'm trying to operate a macro that loops through all connections strings in a workbook and defines them to their base form as defined in "DBPath" range below. Is there any way to do this? I get a run time error '13' type mismatch with what I'm currently trying below. Any help would...

Good Afternoon, I have created a set of code which works in Excel 2010 and 2007 to do the following: 1.) User fills in form as per questions. 2.) User is asked if they have completed other requirements. 3.) Form unlocks checkbox options so user can continue with form. I am now seeing issues...

I am in the process of making a large number of Excel 2000 spreadsheets also work in Excel 2010 and Excel 2013. I have Excel 2000, Excel 2010, and Excel 2013 installed side-by-side on my Windows 7 system. I discovered that when a file (even a very simple file) is created in Excel 2013, and...

Hi, I was wondering how 2013 new features are processed in 2010 version? My concern is that my colleagues using 2010 may not be able to view/use spreadsheets created in 2013 as intended. In particular, how 2010 deals with 2013 new functions like IFNA, or the connected table slicers (i.e. if...

I used to prepare dashboard in Excel 2007, just got 2013 and added one month's data into it, wherein I did not use any unique feature of Excel 13, this worked well on Laptop. Problem occurred after publishing it worldwide, my colleagues who have Excel 2007, they are getting following error...