Software

Ask something
Discussion Locked

Excel spreadsheets slow to load

0 helpful
1 reply

by gareth_bruce

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We use large Excel spreadsheets and they are often slow to load. We have discovered that the speed of loading is severely affected by the default printer driver on the users PC. Where we have Post Script drivers installed, loading can take over 2 1/2 minutes, whereas without a driver it can be only 10 seconds. I assume Excel is reformatting the s/s on loading - can this be bypassed?

1 reply

by dklippert

I don't know of a way to "bypass" the printer, but here are a couple of other suggestions.
Make sure the Workbook is saved as an Excel Workbook, not a multiple version format.

Check the spreadsheets to make sure that some errant formatting isn?tincreasing the file size (use Ctrl+End to find the last used cell)

Change the calculation to Manual, so recalcs are not done when the sheet is opening.

This discussion is closed to new replies.