![]() |
DFunction + Print Preview = Slowdown ???
What can I do to avoid a performance slowdown as a result of the following?
My 100 kb workbook has 3 worksheets, two of which each have 10 DGET functions pulling from the other worksheet database. The worksheets have less than 200 rows each. Calculation and cursor/scroll motion is fine while I make data entry changes, but once I print or use print preview, the workbook slows down considerably like it's really thinking hard. Calculations and cursor/scroll motion go into slow motion mode. I do not have other computer/application problems - the behavior is unique to these actions. I have to complete close Excel to regain the normal performance. Anything I can do to avoid? I really need the DFunction capability. |
All times are GMT +1. The time now is 07:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com