Cell edit takes more than 20 seconds in Excel 2007
 

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.

--

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.

--

Cell edit takes more than 20 seconds in Excel 2007
 

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.

--

Cell edit takes more than 20 seconds in Excel 2007
 

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.

--

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.

--

Cell edit takes more than 20 seconds in Excel 2007
 

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

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

--