LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
al al is offline
external usenet poster
 
Posts: 363
Default Switch calculating cells off

I'm using a massive workbook. Everytime I do anything, the entire workbook
has to re-calculate every formula. This takes too long for me, to have to
wait after every small amendment I make, or after every new cell is updated.

Can I switch off the calculation whilst I make my changes and then swith it
back on again, when I am ready?
 
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
Cells are not calculating on the fly MrWilson Excel Worksheet Functions 3 December 19th 06 04:35 PM
How to switch data between cells? Ruger Excel Worksheet Functions 1 August 25th 06 06:43 AM
Is there a way to switch data between two cells? lhassell Excel Discussion (Misc queries) 1 May 26th 06 06:23 PM
Calculating cells TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 November 2nd 05 01:40 PM
How do I switch arrow key commands for moving to other cells? drivingblind Excel Worksheet Functions 1 November 30th 04 05:06 PM


All times are GMT +1. The time now is 08:56 AM.

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

About Us

"It's about Microsoft Excel"