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 / June 2005

Tip: Looking for answers? Try searching our database.

Why file opens so slowly?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael Brooks - 16 Jun 2005 20:52 GMT
I would welcome any insights as to why one of my Excel files opens soooo
slowly.

I'm running Win 2K, Excel 2000, with plenty of ram and free disk space.
Normally Excel files open in less than a second. But this one has been
taking more and more time, and recently took 10 - 15 minutes. Saving takes a
long time too.

Really the file is not very big, less than a megabyte. The file has three
sheets. One sheet just has a few hundred words of text; the second sheet has
only 20 numbers and a couple of column sums. The largest sheet has 54 rows
and about 50 columns, only 12 of which are numbers, another 12 just dates.
No complicated formulas--just carrying the sum of one column over to the top
of the next column. There are no macros, no code.

It does have a large number of check-box controls (a few hundred). Could
that be a problem?

I could not find any way to delete the checkboxes in design mode, except by
selecting them one at a time...so I created a new file and cut/pasted
everything but the checkboxes. So far the reconstructed file is opening very
quickly.

Do you think:
1. the checkboxes caused a problem? (if so, I'll avoid them in future, at
least in large quantities)
2. or the file was just corrupted somehow?
3. or some other problem?

Thanks!
Dave Peterson - 16 Jun 2005 21:59 GMT
If you've used checkboxes from the control toolbox toolbar, try deleting the
files in the temp folder.

Close excel (and don't be installing any new software)
window start button|run
%temp%

is a quick way to get to that temp folder.

> I would welcome any insights as to why one of my Excel files opens soooo
> slowly.
[quoted text clipped - 26 lines]
>
> Thanks!

Signature

Dave Peterson

Michael Brooks - 17 Jun 2005 18:03 GMT
Many thanks--miraculously, after deleting 10GB from the temp folder, the
original excel file opens much more quickly! I never would have guessed the
solution, but am glad it was something simple!

> If you've used checkboxes from the control toolbox toolbar, try deleting the
> files in the temp folder.
[quoted text clipped - 35 lines]
> >
> > Thanks!
 
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.