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/jadedha...ngCalendar.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

"JT Lovell" wrote in message
...
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

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!

--
JT Lovell

"Keith Willshaw" wrote in message
...

"JT Lovell" wrote in message
...
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

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
"JT Lovell" wrote in message ...
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/jadedha...ngCalendar.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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 21/02/2004

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

"Robert McCurdy" wrote in message ...
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
"JT Lovell" wrote in message ...
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/jadedha...ngCalendar.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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 21/02/2004

"JT Lovell" wrote in message
...
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

Thanks again!

--
JT Lovell

"Keith Willshaw" wrote in message
...

"JT Lovell" wrote in message
...
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