T
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
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