LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cam Cam is offline
external usenet poster
 
Posts: 165
Default HELP! optimize calculating values

Hello,

I have a complex Excel file that have several sheets with calculated formula
and conditional formatting, etc... The raw data came from importing data from
an Access file, then several columns with calculated data. Everytime I change
a value in any rows, it takes forever to recalculate the values in the
formulas, even just changing one value in the row.
Is there an option in Excel that allow me to change all the necessary data,
then update the formulas after all the changes, not update every once change?
Thanks
 
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
How do I optimize system settings to support Excel? ktpinegar Setting up and Configuration of Excel 1 June 23rd 07 01:08 PM
How to use Solver to optimize when the formular contains Round() f BmanSL Excel Discussion (Misc queries) 0 October 30th 06 09:34 AM
Optimize simple macro Biff Excel Worksheet Functions 7 June 2nd 05 01:15 AM
Optimize SumProduct Christopher Kennedy Excel Discussion (Misc queries) 9 December 10th 04 04:47 PM
Optimize SumProduct chris Excel Worksheet Functions 3 December 9th 04 08:39 AM


All times are GMT +1. The time now is 07:34 PM.

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"