Excel 2002 Workbook Opens Very Slowly

[JT Lovell]

I have a very mundane Excel workbook that is used by my department to keep our calendar. It has no macros and no formulas at all. However, it takes over 2 minutes to open the workbook from every computer I've tried it on. I've checked for viruses using McAfee (updated daily) without finding anything at all.

You can download the workbook at http://jadedharem.no-ip.info/jadedharem/Saratoga/Consulting/ConsultingCalendar.xls

Copy and pasting the cells onto a new workbook seems to fix the problem temporarily (it'll open in under 10 seconds), however later deleting of a single row will cause the problem to reappear. I've also tried using SaveAs and renaming it with no improvement.

I'm using Excel 2002 SP-1 running on Windows XP SP-1. If anyone has any ideas or suggestions on what could be causing this I would appreciate it!

 

[Keith Willshaw]

I have a very mundane Excel workbook that is used by my department to keep our calendar.
It has no macros and no formulas at all. However, it takes over 2 minutes to open the workbook
from every computer I've tried it on. I've checked for viruses using

McAfee (updated daily) without finding anything at all.

It does however contain several thousand objects in the shapes collection
which appear to be text boxes

run the following macro to find them

Dim ms As Shape
For Each ms In ActiveSheet.Shapes
On Error Resume Next
Debug.Print ms.Name & " location :-" & ms.TopLeftCell
Next ms

After I deleted them as below the spreadsheet opened in seconds

Dim ms As Shape
For Each ms In ActiveSheet.Shapes
On Error Resume Next
ms.Delete
Next ms

Keith

 

[JT Lovell]

How are these created? The user was only copy/pasting the data from the
calendar around. Will this cause new shapes to be added to the collection?
Is there a way to prevent this from happening again, or will this cleanup
script need to be run periodically?

Thanks for your help!

 

[Robert McCurdy]

You have objects all over the pace.
Little rectangles with no visible boarders or colour.
Goto > F5 > Special > Objects > ok then hit delete.

Save and the file size should drop to 31k.


Regards Robert
I have a very mundane Excel workbook that is used by my department to keep our calendar. It has no macros and no formulas at all. However, it takes over 2 minutes to open the workbook from every computer I've tried it on. I've checked for viruses using McAfee (updated daily) without finding anything at all.

You can download the workbook at http://jadedharem.no-ip.info/jadedharem/Saratoga/Consulting/ConsultingCalendar.xls

Copy and pasting the cells onto a new workbook seems to fix the problem temporarily (it'll open in under 10 seconds), however later deleting of a single row will cause the problem to reappear. I've also tried using SaveAs and renaming it with no improvement.

I'm using Excel 2002 SP-1 running on Windows XP SP-1. If anyone has any ideas or suggestions on what could be causing this I would appreciate it!

 

[JT Lovell]

Great! Thanks!!

Do you know how these get created? Was it likely just a matter of accidentally creating one and then cut/pasting them without knowing it?

--
JT Lovell

You have objects all over the pace.
Little rectangles with no visible boarders or colour.
Goto > F5 > Special > Objects > ok then hit delete.

Save and the file size should drop to 31k.


Regards Robert
I have a very mundane Excel workbook that is used by my department to keep our calendar. It has no macros and no formulas at all. However, it takes over 2 minutes to open the workbook from every computer I've tried it on. I've checked for viruses using McAfee (updated daily) without finding anything at all.

You can download the workbook at http://jadedharem.no-ip.info/jadedharem/Saratoga/Consulting/ConsultingCalendar.xls

Copy and pasting the cells onto a new workbook seems to fix the problem temporarily (it'll open in under 10 seconds), however later deleting of a single row will cause the problem to reappear. I've also tried using SaveAs and renaming it with no improvement.

I'm using Excel 2002 SP-1 running on Windows XP SP-1. If anyone has any ideas or suggestions on what could be causing this I would appreciate it!

 

[Keith Willshaw]

How are these created? The user was only copy/pasting the data from the
calendar around.

There was probably just one to start with which got copied again and again

Will this cause new shapes to be added to the collection?
Is there a way to prevent this from happening again, or will this cleanup
script need to be run periodically?

You should be OK from now on, but you can always run the script again

Keith

 

[JT Lovell]

Thanks again!

--
JT Lovell

There was probably just one to start with which got copied again and again


You should be OK from now on, but you can always run the script again

Keith