Excel Add-in function recalculation

[Franck]

Hi,
Have several Excel new functions in my add-in which return data from
DataBase.

Anyway, I can't figure out how to refresh my Excel cells whenever the
linked data in the database are changed.

I don't want to use Application.Calculate/Volatile/CalculateFull stuff
in each of my workbook...

Any idea ?

Thks for help

 

[Fredrik Wahlgren]

Hi,
Have several Excel new functions in my add-in which return data from
DataBase.

Anyway, I can't figure out how to refresh my Excel cells whenever the
linked data in the database are changed.

I don't want to use Application.Calculate/Volatile/CalculateFull stuff
in each of my workbook...

Any idea ?

Thks for help

Manually, you can press CTRL+ALT+F9 This will force Excel to recalculate
every formula.

Programmatically, you can call CalculateFull or CalculateFullRebuild. I
think the former is enough. It was introduced in Excel2000. Here's an
article that you should read. http://www.decisionmodels.com/calcsecretsh.htm

Best Regards,
Fredrik