Problem loading Excel 2007 files in Excel 2003

[BrianW]

Hello
I have instal MS Enterprise 2007 on my PC. When I open my template job file
that I've been using for a number of years and have had no problems with
until now, and save as a job file, I get a "not compatable" error message.
This appearers to be associated to links of unopen books. I can save the job
file as a Excel 2003 file but when it is opened in Excel 2003 an error
message saying "Too many different cell formats" shows. I click "OK" and
then the file reloads again showing the error message "Too many different
cell formats" again. I click "OK" Excel 2003 then extracts data from the
jobfile and a repair dbx shows
"Damage to the file was so extensive that repairs were not possible. Excel
attemped to recover your formulars and values, but some data may be lost or
corrupted. Excel found errors that may cause some recoved data to be put into
wrong sells"

Can anyone help me on this one.
I have uninstalled Enterprise in the mean time and reloaded Office 2003.

 

[Jeremy]

Hi Brian,

We are having the same issue - existing documents that worked just fine in
Excel 2003, when opened in Excel 2007 and saved (in compatability mode, did
not convert to the new format), would then open in Excel 2003 (with the
compatability tool installed) with the same error message. These are large
documents with quite a few worksheets, and obviously a lot of formatting.
However, we never had the issue prior to Excel 2007.

Have you (or anyone) had any luck with this yet? We have noticed that the
files work just fine in Excel 2007, converted or not, so we may just wait
until Office 2007 is ready to rollout.

 

[BrianW]

Hi Jeremy.
I haven't had any other replies. I did read somewhere others having the same
problem. My template is 28 pages, 7mb and formated to its maximum capacity.
I've created it over 15 years and a rewrite for me would be mamoth. Being
self employed its just not an option at the moment. I was able to recover the
work I did by saving as a 97-2003 file. For some unknow reason some of the
files converted file. I unistalled 2007 in the end as it was just to slow
like 75% slower
Brian

 

[GaryLH]

Although I am not taking 2003 files to 2007, I am using 2003. I have large
files (1.5M, 36 tabs) in which I want to add tabs to, additional funtions,
and formats - and also get the "Too many different cell formats". I was
thinking I'd simply hit a ceiling, but now I'm not so sure. I pushed it and
go the same finbal message: "Damage to the file was so extensive that repairs
were not possible. Excel attemped to recover your formulas and values, but
some data may be lost or corrupted. Excel found errors that may cause some
recovered data to be put into
wrong cells".