I try to open 7mb file in beta 2 Excell2007. This file is opened 3 minute.
But I can open this file in old version Excell - 10s
My PS: Athlon3000+ 512mb

When I try to open 115 mb file in Excell2007, I walk with my dog.....

How long does it take to recalculate the file in the older version? Excel
does not automatically recalculate on open, unless you are opening in a newer
version than the one that saved the file.

Jerry

"Theseus" wrote:

I try to open 7mb file in beta 2 Excell2007. This file is opened 3 minute.
But I can open this file in old version Excell - 10s
My PS: Athlon3000+ 512mb

When I try to open 115 mb file in Excell2007, I walk with my dog.....

"Jerry W. Lewis" wrote:

How long does it take to recalculate the file in the older version?

10-15 second

PS Sorry for my English

"Theseus" wrote:

I try to open 7mb file in beta 2 Excell2007. This file is opened 3 minute.
But I can open this file in old version Excell - 10s
My PS: Athlon3000+ 512mb

When I try to open 115 mb file in Excell2007, I walk with my dog.....

A nice little trick I discovered only today for large workbooks.

Set the Print Area to a single cell. Stay with that setting unless you really need to print some of it. And then, set the Print Area for only what you need.

Maybe write a little macro that stores the real Print Area in another name or property, set the active Print Area to a single cell, then assign a macro to the Print/Print Preview buttons that re-instate the real Print Area before printing/previewing.

I find it speeds up my large workbooks by around 4-8 times!!!

Regards,
BizMark