"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