Cell edit takes more than 20 seconds in Excel 2007

[Mr Toys]

I'm having a problem with a workbook in Excel 2007.

On one particular sheet, editing cells in particular rows causes a delay of
approximately 20 seconds. The workbook is unusable.

I've set calculation to manual and have programatically set
workbook.forcefullcalculation = true but it's still happening. I've deleted
sheets with pivot tables but this hasn't helped either.

Would be grateful for suggestions.

--

 

[Charles Williams]

Try removing any COM addins (Particularly Google)
office Blob-->XL Options-->Addins-->Com Addins-->Remove

And check for any linked pictures or controls

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Mr Toys]

Thanks for the suggestion,

I removed all active add-ins (google and ods) but problem still persists.
It's only effecting some rows which is wierd
--
<a href="http://www.toysonline.ie/toyblog">My Blog</a>

Try removing any COM addins (Particularly Google)
office Blob-->XL Options-->Addins-->Com Addins-->Remove

And check for any linked pictures or controls

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Charles Williams]

If you can send me a zipped copy of the file I will be happy to take a look.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

Thanks for the suggestion,

I removed all active add-ins (google and ods) but problem still persists.
It's only effecting some rows which is wierd

 

[Mr Toys]

Many thanks - where shoud I send it?

 

[Charles Williams]

my Email is Charles at DecisionModels.com
If its too large to email let me know and we will use another method.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com