Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autocalculate to include my function
I have created a small function in module1. The function works correctly
when entered in the worksheet but does not auto recalculate when some of the data it uses is updated. Can I force the recalculation to include this function? John. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
autocalculate to include my function
Hi John,
Please post the code of the function and the formula with which you call it. Probably the reason for not recalculating is that you access some cells directly from within the function. All input to a function should be via the argument list; otherwise Excel is not aware of the need for recalculation. A workaround is to include "Application.Volatile" in your function. However, that may slow down recalculation of your workbook and it is not guaranteed that it will be recalculated correctly in future versions of Excel. The only *correct* way is to include all input in the argument list. -- Kind regards, Niek Otten "John F" wrote in message ... I have created a small function in module1. The function works correctly when entered in the worksheet but does not auto recalculate when some of the data it uses is updated. Can I force the recalculation to include this function? John. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
autocalculate to include my function
Public Function myFunction()
Application.Volatile End Function so using applicaton.Volatile will cause it to be recalced on every calculation. The alternative is to make the dependent cells part of the argument list for the function. This is what excel used to determine which cells it is dependent on. -- Regards, Tom Ogilvy "John F" wrote in message ... I have created a small function in module1. The function works correctly when entered in the worksheet but does not auto recalculate when some of the data it uses is updated. Can I force the recalculation to include this function? John. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Function that does not include 0 | Excel Worksheet Functions | |||
Can I include both AND and OR in the same function? | Excel Worksheet Functions | |||
how do I include advance payments in the PMT function | Excel Worksheet Functions | |||
Can SUMIF function include AND function | Excel Worksheet Functions | |||
Include Saturday in the WORKDAY function | Excel Worksheet Functions |