• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

Excel compatibility checker for 2003

I have a xlsm file that I'm trying to save as xls. Every time, it tells me that there is a compatibility error in the formatting. Is there a way to find out where the problem is, so that I can just change it?
I clicked "Copy to new sheet", but it didn't give me any additional information.
0
etech0
Asked:
etech0
  • 2
1 Solution
 
JohnBusiness Consultant (Owner)Commented:
That was a new format introduced with Excel 2007 (and so did not exist in Excel 2003). Try the following article that indicates how to get the XLSM file back to XLS format.

http://www.ehow.com/how_6134520_convert-xlsm-xls.html

.... Thinkpads_User
0
 
etech0Author Commented:
Hi!
I found this http://superuser.com/questions/322919/excel-compatibility-report-how-do-i-find-the-offending-cells which told me how to find colors that work with 2003. I think that fixed it.
Thanks for your help!
0
 
JohnBusiness Consultant (Owner)Commented:
Thank you, and I was pleased to assist. ... Thinkpads_User
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now