Julie has attended:
Excel Intermediate course
Excel Advanced course
Compatibility Checker
Hi Support Team
I have opened a new excel worksheet and changed some of the data and when I save the new data a message appears.
Do I press continue or i keep pressing cancel. I can't send you the message. Is it because I have changed the formulas from one sheet to the next?
Many thanks
julie
RE: Compatibility Checker
Hello Julie,
Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.
Thank you for your question regarding the Compatibility Checker.
The Compatibility Checker dialogue box only opens when you try to save an older version Excel file (2003) after you have been working on it in 2007. If you click continue, the save will take place, but some of the newer features only available in 2007 will not be saved. The alternative is to click cancel, then click the Office button and then move your mouse to Save As. Here you must choose the type of save you require. So, choose Excel Workbook at the top of the list, and the file will now be saved as a 2007 file format (.xlsx) Make sure from then on to use the newly saved file.
You will always have this issue with older version files but over time they all will be saved with the new file extension so be patient!
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer