Slow Code
 

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?



--
Thanks
Shawn

Slow Code
 

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


On Mon, 25 Jan 2010 07:15:01 -0800, Shawn
wrote:

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?

Slow Code
 

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