ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   DFunction + Print Preview = Slowdown ??? (https://www.excelbanter.com/excel-worksheet-functions/84485-dfunction-print-preview-%3D-slowdown.html)

Jon Young

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