| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. -- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. -- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. -- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. -- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. -- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Takes 30 Seconds Plus to Save First Time | Excel Discussion (Misc queries) | |||
| Saving takes 30 Seconds | Excel Discussion (Misc queries) | |||
| Copying single cell takes 15-20 seconds | Excel Discussion (Misc queries) | |||
| macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting | Excel Worksheet Functions | |||
| Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
Linear Mode
