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.