LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Problem with formula - Taking too long for calculation

Hi,

I have about 15 worksheets (more than 2000 formulas / sheet) all formula
based. All these worksheet gets data from Data sheet (about 65,000 records).
Whenever i change anything on the data side, it takes too long to
recalculate (Sometimes i may need to change several data values) .
Is there any workaround to get this faster? Or is there a way where i can
tell excel to recalculate when i want to ?

Thanks in advance.


 
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 to pdf taking too long in 2007 Milind Keer[_2_] Excel Discussion (Misc queries) 1 February 23rd 10 08:05 PM
Excel to PDF taking too long Milind Keer[_2_] Excel Discussion (Misc queries) 1 February 23rd 10 06:38 PM
calculation taking too long yowzers Excel Worksheet Functions 8 December 15th 09 11:25 PM
taking a long list of duplicates... DFrank Excel Discussion (Misc queries) 4 June 27th 08 10:21 PM
External Links Taking too long Sean Excel Discussion (Misc queries) 1 November 27th 06 11:30 AM


All times are GMT +1. The time now is 12: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"