compatibility checker
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Compatibility Checker

resolvedResolved · Low Priority · Version 2007

replyReply Thu 18 Nov 2010, 17:45Delegate Julie said...

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

For upcoming training course dates see: Pricing & availability

replyReply Fri 19 Nov 2010, 16:15Trainer Rodney said...

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.

 

Please browse our web site to find out more about
excel consultancy and other Microsoft training courses.

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard