compatibility checker

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Compatibility Checker

Compatibility Checker

resolvedResolved · Low Priority · Version 2007

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

Fri 26 Nov 2010: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips


Server loaded in 0.09 secs.