ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel RTD function calculates functions twice (https://www.excelbanter.com/excel-programming/390690-excel-rtd-function-calculates-functions-twice.html)

amar

Excel RTD function calculates functions twice
 
Hi all,

I am using excel RTD function within a wrapper function in an addin.
The function works fine except when i change the input parameters.

For example:
1. I open a workbook and use the RTD function within my wrapper function.
2. Works allright, so i save my workbook.
3. I open another blank workbook and change the input parameters to the RTD
function in my addin and save it.
4 Now i open my previously saved workbook.
5. Now, excel calls the RTD function with the parameters it used when this
workbook was last saved. I have no idea where it stores these values..

So it sends all the previously saved parameters to the RTD server and then
removes them all and then again recalculates all the RTD functions with the
new parameters.

Any ideas why this is happening?
Any thoughts on how this could be avoided?

Any help is greatly appreciated

Regards
Amar


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com