Slow Code

  • Thread starter Thread starter Shawn
  • Start date Start date
S

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?
 
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
 
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
 
Back
Top