View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mr Toys Mr Toys is offline
external usenet poster
 
Posts: 3
Default Cell edit takes more than 20 seconds in Excel 2007

Many thanks - where shoud I send it?
--
<a href="http://www.toysonline.ie/toyblog"My Blog</a


"Charles Williams" wrote:

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

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


"Charles Williams" wrote:

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.

--