Solved

Error in Excel 2003 but not 2010

Posted on 2011-03-23
6
206 Views
Last Modified: 2012-05-11
I created a workbook that has a ton of formulas and a few macros in Excel 2003 and tested the workbook with the end user community.  After we released the workbook for production processing people in the field started getting the following error after saving and trying to reopen:

Excel found unredable content in 'filename.xls' Do you want to recover the content of this workbook?

This is happening intermittently and the file open no problem in Excel 2010 without any error's reported.  I have to figure out why this is happening as there are about 100 instances of this workbook in the field right now and this is happening to about 15 of the workbooks.  I did find circular references in one case but not all when I opened in 2010 and eliminating all circular references fized the problem and I was able to open in 2003 again without losing anything.  This was only true in one case though and I can not find circular references in any of the others that had errors.  Has anyone ever seen this happen before and is there a logical solution?
0
Comment
Question by:R_M_Ron
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 35205581
Please check this:

http://support.microsoft.com/kb/929766

jppinto
0
 
LVL 6

Accepted Solution

by:
FernandoFernandes earned 500 total points
ID: 35205803
check the names collection through VBA,
Alt F11
Ctrl+G
Type: ?activeworkbook.Names.count
then enter.
if the number is higher than 65472, then u need to clear names until the number is below that. You can only do it with Excel 2007 or 2010, since 2003 will always think the file is unreadable.
More:
excessive number of formats/validations/conditional formatting, also can break the file, but not make it unreadable. The best suggestion is if you could, upload the file, then I can make thorough investigation with it.

if u cant, u could do it yourself starting with check compatibility under File/Info (Office 2010)...

and you should have all your field usin the same version of Excel, it's safer! And the file itself should be the new xml formats instead of the old format as the new format does not have the limitations mentioned in this post.

hope it helped somehow!
0
 
LVL 20

Expert Comment

by:clarkscott
ID: 35205981
I suggest you do all the editing using Excel 2003.  2010 will 'convert' everything upon opening, but 2003 won't convert 2010 stuff (even if the code is the same).   This also pertains to REFERENCE Files.  If you do all your work in 2003, 2010 will (hopefully) automatically assign the 'next version' of the ref. file.  This process does NOT work backwards.  If you write in 2010 (even if in 'converted mode'), the reference files 2010 uses will crash in 2003.

I don't know if this is your solution... but it's good to remember.

Scott C
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Author Comment

by:R_M_Ron
ID: 35212744
Thank you everyone for the leads here.  I am getting back to this tonight and will try all of these solutions (I got bogged down with server admin tasks today so looks like I will be working this late again tonight)
0
 

Author Closing Comment

by:R_M_Ron
ID: 35212880
This ended up being related to Defined Names that were causing problems with data validation ranges.  The defined names were in an older version (that I did not create) and I never removed the references to the names.  Not sure why they were corrupting the file but when I deleted the invalid named ranges in 2010 and saved, I was able to open in 2003 again and could not cause the same problem.  You saved me a TON of headache. THANKS!!!!!
0
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35212900
:)
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question