Davide Crudo
Posts: 23
Joined: 2005-05-09
|
I have a function in an Excel worksheet,
but pressing F9 will not refresh all the cells.
Basically the function retrieves data from a database to do a calculation. The only way to refresh is to Press F2 on the cell and then enter. At that point the cell is recalculate.
But what if in my worksheet I have 300 or more formulas? i cannot do F2 on each cell... is there a global refresh procedure?
thank you in advance! |
|
Dmitry Kostochko
Add-in Express team
Posts: 2887
Joined: 2004-04-05
|
Hi Davide,
Try to add the following code line to your function.
begin
//
// your code
//
COMAddInModule.ExcelApp.Volatile;
end;
|
|
Davide Crudo
Posts: 23
Joined: 2005-05-09
|
Thx!!! It works perfectly!
|
|