Solved

Error in Excel 2003 but not 2010

Posted on 2011-03-23
6
203 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
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now