Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Long file load time @ 100% CPU - Excel 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil - 31 Mar 2008 11:07 GMT
Hi All,

I've got an .xls file (97 - 03) that has been worked on for a number of days
now, suddenly it now takes minutes to load (it consists of two active
sheets, total size is 2.55 Mb).
It saves quickly enough, however even if I save it using another name, it
takes minutes to load.
I have attempted to load it using Excel 2007 with 'open & repair' but still
have the delay.
I'm using Win XP Pro, the file was created using Excel 2003.
The problem occurs across machines.
Once opened, it seems to behave OK.

Any ideas on how I might fix this file ?

Thanks.

Neil
Pe®sonaG®ata - 31 Mar 2008 11:23 GMT
Check if there is a macro running at the background.
KdR

--------------------------------

Hi All,

I've got an .xls file (97 - 03) that has been worked on for a number
of days
now, suddenly it now takes minutes to load (it consists of two active
sheets, total size is 2.55 Mb).
It saves quickly enough, however even if I save it using another
name, it
takes minutes to load.
I have attempted to load it using Excel 2007 with 'open & repair' but
still
have the delay.
I'm using Win XP Pro, the file was created using Excel 2003.
The problem occurs across machines.
Once opened, it seems to behave OK.

Any ideas on how I might fix this file ?

Thanks.

Neil
Neil - 31 Mar 2008 11:38 GMT
Hi All,

What I did find on further investigation was that the user had hidden rows
400 - 65536.
This part of the sheet had formatting, borders - you name it.

As soon as I transferred just the visible rows to another (new) sheet in the
same workbook and deleted the original sheet - problem solved !

Thanks.

Neil

> Check if there is a macro running at the background.
> KdR
[quoted text clipped - 22 lines]
>
> Neil

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.