How to make custom formula not to calculate on opening or closing or any updation in file

Hi,

I have created one custom formula which calculates running balance from some table of database Access in excel.
I have written this formula in a Macro of excel Module and created an addin.
now I have around 20 to 30 sheets where this formula is used in each sheet around 50 times this formula is used.

If i make any changes in my excel sheet suppose deleting or inserting any row it starts calculating every sheet where ever the formula is written
how i can control the formula calculation up to that cell only and it should not recalculate other sheets.

Thanks in advance
Himvj

Hi,

Use below formula in Macro to restrict your calculations.

Please Login or Register  to view this content.

Change the name of Sheet1 as per your requirement.

regards
taps

Note: If your purpose solved then mark this thread as SOLVED