ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   very slow spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/31346-very-slow-spreadsheet.html)

joe

very slow spreadsheet
 
This sheet has links to several other sheets. it has worked fine for several
years. Now it is very slow and doesn't respond if I got to print preview or
try to print. I have removed and reinstalled Office and that didn't help.
Is there a way to find out what is causing this? or How to fix it?
Thanks

Norman Jones

Hi Joe,

One possibility is that the workbook's file size has expanded considerably
beyond its 'real' data range. See Debra Dalgleish's notes on UsedRange at:

http://www.contextures.com/xlfaqApp.html#Unused

---
Regards,
Norman



"joe" wrote in message
...
This sheet has links to several other sheets. it has worked fine for
several
years. Now it is very slow and doesn't respond if I got to print preview
or
try to print. I have removed and reinstalled Office and that didn't help.
Is there a way to find out what is causing this? or How to fix it?
Thanks





All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com