Using manual calculation - hitting F9 brings up Run time error '1004'

[booms]

Hi,

Bizarre problem I haven't seen before.

I'm opening up a fresh Excel session, and I've turned Calculation to Manual in options. On hitting F9 I get the error:

Run time error '1004'
Method 'Calculation' of object '_Application' failed

I've not changed any code or attempted to use any VBA - even just trying to recalculate a formula in A3 where it is =A1+A2 causes the above error.

Anyone come across this? It hasn't previously been a problem so I'm a bit confused.

Thanks

 

[Andrew Poulsom]

Do you have any Add-Ins installed? Do you have any Worksheet_calculate event code?

 

[booms]

Do you have any Add-Ins installed? Do you have any Worksheet_calculate event code?

Using a corporate PC so it's a bit difficult - there are lots of add-ins but none of my colleagues have the problem and I'm not aware any of the add-ins have changed.

I've looked in the editor on that sheet and set to Worksheet and Calculate - but there's nothing unusual there so I don't think there are any worksheet events set up.

 

[Andrew Poulsom]

Do you get the option to Debug?

 

[booms]

Do you get the option to Debug?

No - it's greyed out. I can only select 'End'

 

[Andrew Poulsom]

You have a macro running somewhere. Try without any Add-Ins installed.