View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Cell edit takes more than 20 seconds in Excel 2007

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

--