Bunchil
asked on
Loss of excel spreadsheet functionality
Hi All, I have an xlsm file saved from versions of Excel 2007 and 2013 that I need to save in Excel 2003 format for some users. When I select the 'Save As' option a select the 2003 format I get error messages about the the loss of functionality (see attached word file).
The errors indicate:
1. Data outside row and column limit for 2003 - checked and it is not true
2. Data validation rules that refer to values on other worksheets - checked and not true
3. Formulas linked to other worksheets that are closed (the link is said to be in Defined Names) - check and I have not links to other workbooks either in formulae or in defined names.
Can any one advise how to fix these problems please.The-following-features-in-this-workbook-
The errors indicate:
1. Data outside row and column limit for 2003 - checked and it is not true
2. Data validation rules that refer to values on other worksheets - checked and not true
3. Formulas linked to other worksheets that are closed (the link is said to be in Defined Names) - check and I have not links to other workbooks either in formulae or in defined names.
Can any one advise how to fix these problems please.The-following-features-in-this-workbook-
They are more warnings than errors. Have you checked the 2003 version of the file to see if it is OK?
ASKER
Hi Wayne, Yes and the file works perfectly in Excel 2003.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BTW, instead of having to manage 2 file formats, use the one (XL2013) and have the other users install the Compatibility Pack.
You can try opening the new xls file in 2013 and resave it as an xlsm to eliminate the warnings. Keep the original xlsm file intact just in case you need to revert to it.
ASKER
Thank you Wayne, I have been doing as you suggested but was concerned that there might be issues I wasn't aware of.
Regards
Bunchil
Regards
Bunchil