application.volatile?

[rgandy]

I have a program which contains thousands of uses of custom functions
I do not want these to recalculate on each instance of an operation being performed on teh spreadsheet (ie. inserting a row, pressing F9)
to accomplish this, i have used the application.volatile method
unfortunately, the functions seem to all recalculate despite this
any suggestions?
thanks

 

[SkipVought]

Hi,

How about Tools/Calculation - MANUAL?

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[rgandy]

skip,
it is on manual already
are there any other properites on functions that can dictate how often they recalculate?
would inserting a row force a calculation despite the volatile method equaling false?

 

[SkipVought]

Why are you inserting rows? I find that most often it is much better to append data to the bottom of a table and sort, if necessary. Don't know if that would solve your problem or not.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[rgandy]

skip,
inserting rows because i had to adhere to a parcitular format that implements layers or subtotals that change from each instance to the next, and based on user requests. therefore i begin from the outside and work my way in, inserting rows when necessary
in my estimation there is no more efficient way to do this. it has never been a problem until now with the addition of all of these formulas needed to perform a particular function. seems to really labor through those recalcs
thanks for the advice

 

[SkipVought]

Then it still ought to be able to be SORTED of you're using subtotals.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}