Slow Opening & Closing Documents

R

Ruthy

I have a workbook with about 15-20 worksheets. Each worksheet has several
check boxes. It is extremely slow opening and closing the document. Is there
anything I can do to improve the performance? I don't know anything about
macros. I only use the check boxes and other text in the worksheets. Does the
number of cells used effect performance? What about color?
 
E

Eva Shanley

The number of rows and columns Excel thinks is being used
could greatly increase the size of your file, making it
slow to work with. Select cell A1 in each sheet, then
press Ctrl + End to see what the last used cell on the
sheet is. If you have extra rows and columns without
data, delete them. Save the file when you're done.
HTH.
 
D

Dave Peterson

If those checkboxes are from the Control Toolbox toolbar, try cleaning up your
windows temp folder.

In fact, this might help no matter what.
 
R

Ruthy

They are from the control toolbar. I did a disk cleanup and it still takes at
least 5-10 minutes to open the document. Is there any other option besides
check boxes? Is it the check boxes that are slowing down the doc?
 
L

Lady Layla

Disk Cleanup may or may not clean the area where you need it to clean. You need
to physically go to the c:\windows\temp and c:\documents and settings\<your
name>\local settings\temp directory and delete all files and subfolders there.

Also do you have an AV on your computer? What type? Is it scanning all files
or select files?


: They are from the control toolbar. I did a disk cleanup and it still takes at
: least 5-10 minutes to open the document. Is there any other option besides
: check boxes? Is it the check boxes that are slowing down the doc?
:
: "Dave Peterson" wrote:
:
: > If those checkboxes are from the Control Toolbox toolbar, try cleaning up
your
: > windows temp folder.
: >
: > In fact, this might help no matter what.
: >
: > Ruthy wrote:
: > >
: > > I have a workbook with about 15-20 worksheets. Each worksheet has several
: > > check boxes. It is extremely slow opening and closing the document. Is
there
: > > anything I can do to improve the performance? I don't know anything about
: > > macros. I only use the check boxes and other text in the worksheets. Does
the
: > > number of cells used effect performance? What about color?
: >
: > --
: >
: > Dave Peterson
: > [email protected]
: >
 
R

Ruthy

I don't have a windows folder, but I searched for all the temp files and
deleted them. I am using Norton, and I'm sure it is scanning everthing. My
main concern is when I send this file to others for use, will they have as
difficult a time opening it as I do???
 
D

Dave Peterson

A quick way to get to the windows Temp folder:

Windows start button|Run
%temp%
(and hit enter)

If this is the problem--and I'm not sure we've verified that it is, then it's
local to you--well, unless they have tons of stuff in their own Temp folder.

(Your windows folder could be called Winnt, too--it's vary with the version of
windows. But in any case, that quick way will work.)
 
R

Ruthy

I think this might be it! With your instructions, I located the temp files
that I could not see before. there are 10000 emf files that appear to be from
the check boxes. Can I delete these just like tmp files?
 
D

Dave Peterson

I would.

Close excel (and maybe any other programs you have running)
And don't be in the middle of installing/removing any other programs!

Then delete at will!

I figure that if any program writes to a folder called Temp, it knows that it's
not a permanent solution.

I keep a shortcut on my desktop to clean it up (on demand).

Here's where I got the VBS code:
http://groups.google.com/groups?threadm=#bXVsIHnAHA.920@tkmsftngp02

I find that clicking on a that shortcut icon much easier than finding that temp
folder--and sometimes those temp files can be in use -- so deleting becomes a
pain. I'll sort by the date (in detail view), and delete anything that was
created before today. (Those files shouldn't be in use.)

(I like that VBS shortcut a lot!)
 
R

Ruthy

You are AWESOME! This helped tremendously......

Dave Peterson said:
I would.

Close excel (and maybe any other programs you have running)
And don't be in the middle of installing/removing any other programs!

Then delete at will!

I figure that if any program writes to a folder called Temp, it knows that it's
not a permanent solution.

I keep a shortcut on my desktop to clean it up (on demand).

Here's where I got the VBS code:
http://groups.google.com/groups?threadm=#bXVsIHnAHA.920@tkmsftngp02

I find that clicking on a that shortcut icon much easier than finding that temp
folder--and sometimes those temp files can be in use -- so deleting becomes a
pain. I'll sort by the date (in detail view), and delete anything that was
created before today. (Those files shouldn't be in use.)

(I like that VBS shortcut a lot!)
Click to expand...
 
Top