N/APosted on - 01/11/2012
I have a problem in saving my MS Excel files created from the earlier version 97-2003 to the newer version which is 2007. Sometimes when I do this, some formula will not work properly. A notification appears that some of the formulas and data will not update will not be updated. How will I solve this problem?
Is there a button I should click so that the whole file will work?
Problem in saving my MS Excel files created from the earlier version
There are two things that I will suggest that you do:
First, you will need to make sure that when saving your document in the recent version of excel that you have on your computer, you are saving the document in the compatibility format as follows: Go to file >> Save as >> Excel 97-2003 workbook and then save it.
The second thing that you may want to do is upgrade the version of excel that you are using on the other computer. If you are using the older version of excel like excel 2003, then you will need to upgrade to the latest version which could be excel 200 7 or the ms excel 2010.