Shared Spreadsheet Problem

[Thomas M.]

Excel 2003

We have a small group of users who share a spreadsheet. The spreadsheet is
about 2 MB in size. The users have complained that the spreadsheet scrolls
very slowly. As I understand it, the users clean the data out of the
spreadsheet each month, but at the moment it is not clear to me how they do
that. My preference would be that they have a template file that they use
to start fresh each month, but my guess is that they simply delete the data
at the end of the month and then enter the data for the new month into the
same spreadsheet file.

What would cause a shared file to start having problems with slow scrolling?
Is it just the size of the file? Are there any performance options that can
be set to make Excel handle the file with more speed and agility?

FWIW, the task for which the spreadsheet is being used just screams out for
a database, but that idea has been rejected by the unit supervisor.

--Tom

 

[JP]

Hello,

A few suggestions:

1. Turn off calculation (but you risk using old data).
2. Reset the used range of the file by running activesheet.usedrange
in the VBE immediate window.
3. Get rid of array formulas.


HTH,
JP