Excel 2007 - incorrect file corruption error

For Microsoft info and product "improvement"...

Excel 2007 trial edition running under Vista Home Premium, 2GB RAM, T7200
processor.

Attempted to open a big* spreadsheet saved from Excell 2002 and was told
that the macros were corrupted (and sheet display was incorrect)

* Big = 63MB on disk; 256 cols, ~4000 rows; 128 cols contain simple
reference formulae, e.g. =$A$20; 128 cols containing 160 chars of text each
cell; ~300,000 drawn arrows between cells

Re-opened the same file in Excel 2002 and it's all just fine.

Additional issues...

1. Opening in Excel 2007, Excel peaked at 1.6GB (!) private memory usage; pc
ground to a halt as memory utilisation reached 93-95% overall [Excel 2002
peaked at about 90MB]
2. Even without the "corrupt" macros Excel did not correctly display the
spreadsheet, initial view 10% scale, no sign of the drawn arrows
3. Vista incorrectly indicates Excel "not responding" - true in one respect,
but Excel certainly not dead just very very busy... problem common to Office
apps generally... need a better mechanism for detecting dead apps
4. My god was it slow! Even after allowance for up-front virus scanning, I
estimate Excel XP as 3-5 faster (and more accurate!) in opening the document

Net result, Excel 2007 20x memory usage, at most 1/3 speed and incorrect
with respect to Excel 2002.

Doesn't bode very well for the "trial" does it?

Julian Moore

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=03bce...-0743-4

Juian

This sort of behaviour is shown when Excel gets confused over files in the
xlStart folder, if these are not needed. Personal.xls, book.xlt, sheet.xlt
etc then delete them and you may find an improvement

Also on the v/s front. If this is old and has office integration, as many
do, it may be getting confused with the new file formats

Certainly don't see those issues here. Vista Ultimate (low spec laptop) and
Office 2007, co-existing with 2003

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT DeleteThis @zen.co.ukANDTHIS
www.nickhodge.co.uk


"Julian" <Julian DeleteThis @discussions.microsoft.com> wrote in message
news:03BCE83E-0743-4DC5-9525-207C84878AAB@microsoft.com...
> For Microsoft info and product "improvement"...
>
> Excel 2007 trial edition running under Vista Home Premium, 2GB RAM, T7200
> processor.
>
> Attempted to open a big* spreadsheet saved from Excell 2002 and was told
> that the macros were corrupted (and sheet display was incorrect)
>
> * Big = 63MB on disk; 256 cols, ~4000 rows; 128 cols contain simple
> reference formulae, e.g. =$A$20; 128 cols containing 160 chars of text
> each
> cell; ~300,000 drawn arrows between cells
>
> Re-opened the same file in Excel 2002 and it's all just fine.
>
> Additional issues...
>
> 1. Opening in Excel 2007, Excel peaked at 1.6GB (!) private memory usage;
> pc
> ground to a halt as memory utilisation reached 93-95% overall [Excel 2002
> peaked at about 90MB]
> 2. Even without the "corrupt" macros Excel did not correctly display the
> spreadsheet, initial view 10% scale, no sign of the drawn arrows
> 3. Vista incorrectly indicates Excel "not responding" - true in one
> respect,
> but Excel certainly not dead just very very busy... problem common to
> Office
> apps generally... need a better mechanism for detecting dead apps
> 4. My god was it slow! Even after allowance for up-front virus scanning, I
> estimate Excel XP as 3-5 faster (and more accurate!) in opening the
> document
>
> Net result, Excel 2007 20x memory usage, at most 1/3 speed and incorrect
> with respect to Excel 2002.
>
> Doesn't bode very well for the "trial" does it?
>
> Julian Moore
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=03bce...-0743-4