#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default calculate

From that URL, it seems that the problem is related to a large number
of lookup fucntions, each looking at the same, very wide, range.

The recalc time is instantaneous, even though it is apparantly a full
recalc. If it is simply a full recalc problem, then the results are
correct, right? It also seems that formual auditing is disabled,
which is distrurbing to me, as I like to audit the file with those.

Thru some tests, the author finds that, apparently, the symptom is
triggered when a 5824th exact same lookup referecne is added, so
perhaps that clears the 8,000 issue from being the problem and it is
more related to the repeated use of large lookup ranges.

I do beleive, if we can find the exact cuase, that this file could be
reporgrammed to fix the problem. I think the wide ranges were just
the easiest way to do it, but that they could be narrowed with not too
much trouble.

Thanks so much for your response, Charles.
Dean
Reply
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
Calculate % Amin Excel Worksheet Functions 4 May 28th 10 02:19 PM
Calculate the value of Z Harshad[_2_] Excel Discussion (Misc queries) 12 September 29th 08 08:12 AM
calculate time does not calculate Wanna Learn Excel Discussion (Misc queries) 4 August 19th 08 12:51 AM
Activesheet.Calculate failing to calculate Daniel Bonallack Excel Programming 2 October 11th 06 03:16 AM
Macro that hide or unhide and not calculate or calculate Jonsson Excel Programming 1 August 19th 03 04:22 PM


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