My excel function does not calculate on loading sheet

Jan 6, 2015 at 5:58 AM
Hi,
I call my excel function on some cell and get data from service and display it on excel.After that, I save my sheet and close. Again reloading sheet the function should get called and get new data from service but its not happening.Is there something extra to do so.
Coordinator
Jan 6, 2015 at 5:36 PM
Hi,

This is normal, as far as I know. Excel does not recalculate a sheet when you open it, unless it was saved in a previous version or something.

If you marked the function as volatile, it would recalculate (but would also recalculate after any change on the sheet during normal use).
I guess one could also make a macro or event handler that recalculates every worksheet that is opened.

Anyway, I don't know much about the recalculation details for Excel, but Excel-DNA does not interfere with it.

-Govert