LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Help with Function/Formula Overloads

Hello....

I was wondering just how much Excel 2003 can take with regards to massive
amounts of Functions/Formula? I have a workbook and two worksheets have many
functions in it and every time I make a slight change to anything it takes
about 15 minutes to recalculate everything... even if I do not make a change
to a formula/function or the data that the are pulling from.


if there is an issue with this can someone help me with thinning out my
mess.? Currently I have on one sheet -- seven columns with 1003 rows that
have a formula/function in each and every cell. On that sheet alone that's
7021 cells with code and over 30,000 "IF" Statements/checks. On the other
sheet, I have at least 5 times as much.


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
Help with function / Formula Jerry Bailey Excel Worksheet Functions 4 January 29th 09 05:09 AM
Help with OR function in IF function formula veggies27 Excel Worksheet Functions 3 March 18th 08 10:04 PM
how do i add a function to a formula? david_b2 Excel Discussion (Misc queries) 9 October 10th 06 05:15 PM
A formula/function to return a formula/function sith janitor Excel Worksheet Functions 4 September 22nd 06 05:01 PM
Formula/function alm09 Excel Worksheet Functions 3 May 5th 05 11:12 PM


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