Numbers slow to enter, text fast, Excel 2007 Worksheet setting to blame?

[swil77]

I've an excel sheet made with Office 2007, when a number is entered in a cell on Sheet1 and Enter pressed it takes 2 seconds to respond. When text is entered it's instant.

On every other worksheet numbers are instant so it doesn't seem to be a global setting causing it.

I've deleted every row and column from Sheet1 and the delay still occurs.

It seems some setting on that worksheet is causing a delay on numbers only, has anyone come across this before? I thought it may be verification turned on as I've used that on this sheet but seems not. I also tried turning off instant calculations to no effect.

I'd just make a new Workbook but the workbook this cleaned sheet is from is at its 30th version and has taken a long time to build and is very complicated, I've uploaded the workbook with all cells deleted still displaying the error to the following link.

https://rapidshare.com/files/461676109/test1.xlsx

Thank you

 

[Sektor]

Execute this macro:

Sub DeleteShapes
    
    Dim shp As Shape
    
    For Each shp In Sheet1.Shapes
        shp.Delete
    Next

End Sub

 

[Sektor]

As an alternative:
1. Unzip Excel file
2. Delete folder "\xl\drawings".
3. Zip back.

When launching file, press "Yes" in appeared window. That's it!

 

[RoryA]

Or:
f5
Press Special... button and select Objects from the list, then OK. Then press Delete key.

 

[swil77]

Wow you both solved the problem and fast! this is an incredible forum, thank you! I was pulling my hair out over this for hours.

 

[JasonRae]

Or:
f5
Press Special... button and select Objects from the list, then OK. Then press Delete key.

Hi, I have the same problem and is super slow most days. I have buttons up the top in a frozen row but these are all quick access to different macros. So I would really like to not delete them. Any reason the objects are slowing it all down? Is there a better was to have macro buttons?

 

[RoryA]

It's not the presence of a few macro buttons that is the problem in this case - it was thousands of irrelevant shapes on the sheet and those are what needed to be deleted.