Excel 2007 - incorrect file corruption error

[Julian]

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/com...4878aab&dg=microsoft.public.excel.crashesgpfs

 

[Nick Hodge]

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
(e-mail address removed)
www.nickhodge.co.uk

 

[Julian]

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

Nick

That's helpful and interesting; unfortunately my trial installation is
FOOBAR'd (MS now investigating!) so I can't try anything for a while!

And useful though the info is, sounds pretty much like a dropped brick on MS
part if it can be so easily "confused"!

Anyway...FYI virus scanning is AVG Free [I can't see why v/s should care
about formats - if it passes through it passes through... surely? Well, I
guess experience suggests otherwise <LOL> ]

Curious about Excel getting "confused" - I will have my own Personal.xls
with macros etc, did you mean clear xlStart out and reload it or never put
anything in there at all?

Thanks... any more on this anywhere?

Julian

 

[Nick Hodge]

Julian

I don't keep a personal.xls in my xlStart so I meant delete it and create a
new one to see if that works. XL2007 seems not to like hidden workbooks
(personal.xls, book.xlt, etc) in the old format. Of course you could set up
an alternate start-up location for each version under options to load
start-up workbooks specific to the version which should help.

For example during the beta I had a personal.xls which when I opened 2007
(Of course this opened hidden) restricted my grid to compatibility mode
65536x256 although the opened template was book1. Deleting and recreating a
personal.xlsx cured the issue.

Excel 2007 has some issues, charts, shapes, macro recorder,etc, but
stability isn't one I've come across since the early betas

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

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

Nick

That's helpful and interesting; unfortunately my trial installation is
FOOBAR'd (MS now investigating!) so I can't try anything for a while!

And useful though the info is, sounds pretty much like a dropped brick on
MS
part if it can be so easily "confused"!

Anyway...FYI virus scanning is AVG Free [I can't see why v/s should care
about formats - if it passes through it passes through... surely? Well, I
guess experience suggests otherwise <LOL> ]

Curious about Excel getting "confused" - I will have my own Personal.xls
with macros etc, did you mean clear xlStart out and reload it or never put
anything in there at all?

Thanks... any more on this anywhere?

Julian

 

[Julian]

Thanks,

When I can I'll create a Personal.xls (or mod the existing one) - I just
want to include my VBA for custom functions and so on...

I don't *think* I had anything in the xlStart folder that might have been
old-format.... unless the trial installation looked in the same place as the
Office XP installation... ah! maybe that's it

Anyway, all useful info - thanks... no doubt I'll find out about the other
"issues" in due course!

Thanks again

Julian