Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Values For Custom Formulas
Hi,
I have created a custom function to shorten a lengthy sumproduct formula. However, when the source cells' values are changed the custom function's results are not automatically updated & I have to press F9, while the original lengthy formula updates automatically. What might be the reason? How can the same be done so. Thanx! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Values For Custom Formulas
You can add this line of code to your function:
Application.Volatile Like this: Function MyFunct(......) Application.Volatile However, this will cause the function to recalculate *every time* a calculation happens even if the dependent cells didn't change. In which case your original lengthy formula is probably a better choice. -- Biff Microsoft Excel MVP "FARAZ QURESHI" wrote in message ... Hi, I have created a custom function to shorten a lengthy sumproduct formula. However, when the source cells' values are changed the custom function's results are not automatically updated & I have to press F9, while the original lengthy formula updates automatically. What might be the reason? How can the same be done so. Thanx! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Values For Custom Formulas
In addition to Biff's advice:
The best way is to include all input cells in the argument list. That is the only way Excel recognizes the dependencies correctly. Then the function calls will be recalculated when and only when needed. -- Kind regards, Niek Otten Microsoft MVP - Excel "T. Valko" wrote in message ... | You can add this line of code to your function: | | Application.Volatile | | Like this: | | Function MyFunct(......) | Application.Volatile | | However, this will cause the function to recalculate *every time* a | calculation happens even if the dependent cells didn't change. In which case | your original lengthy formula is probably a better choice. | | | -- | Biff | Microsoft Excel MVP | | | "FARAZ QURESHI" wrote in message | ... | Hi, | | I have created a custom function to shorten a lengthy sumproduct formula. | However, when the source cells' values are changed the custom function's | results are not automatically updated & I have to press F9, while the | original lengthy formula updates automatically. | | What might be the reason? How can the same be done so. | | Thanx! | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot custom chart not updating | Charts and Charting in Excel | |||
Updating the date in Custom Header | Excel Discussion (Misc queries) | |||
Custom functions not updating when dependant cells are edited | Excel Discussion (Misc queries) | |||
Custom Function not updating | Excel Worksheet Functions | |||
Custom Function not updating | Excel Worksheet Functions |