LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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.

--

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Takes 30 Seconds Plus to Save First Time [email protected] Excel Discussion (Misc queries) 0 April 22nd 08 02:43 PM
Saving takes 30 Seconds [email protected] Excel Discussion (Misc queries) 7 February 13th 08 03:01 AM
Copying single cell takes 15-20 seconds Jason Woodruff Excel Discussion (Misc queries) 2 August 15th 06 03:14 PM
macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting drdavidge Excel Worksheet Functions 1 July 13th 06 05:48 PM
Edit cell automatically takes you to cell cgrant Excel Worksheet Functions 1 May 20th 05 04:30 PM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"