Slow Code

[Shawn]

I need a suggestion. Employees send their timesheets via email into our
central office. We have an Employee Database created in excel. A VBA copies
and pastes the time sheet information into the Employee Database and stores
it.

There is a hidden sheet in the Employee Database that the copied information
from the Time Sheets gets copied into. I have noticed when I try to unhide
this sheet, it unhides extremely slowly. Why? Is there ghost information
being stored in this sheet that is making it large? Suggestion solution?

 

[Gord Dibben]

I don't know why your hidden sheet is slow to unhide but you don't need to
unhide to copy data to a hidden sheet.


Gord Dibben MS Excel MVP

 

[goshute]

If formulas are copied, check for mega formulas or formulas with
broken links, or links to unopen workbooks. Formatting for entire
columns and rows is another resource hog.

Sometimes, a sheet gets corrupt. Simply copying the worksheets into a
new workbook may help.

Goshute