Problems updating chart in Excel 2002 1

[ac96]

I have a vba addin, within it's menu there is a button
with code for refreshing the sheet incl.
(Application.SendKeys "^%{F9}&quot , this works for Excel
97 - 2000.
the active sheet which has various formulae(calling custom worksheet functions present in my add-in) and charts
drawn from the values resulting from the formulae. In the
case of Excel 2002 for the same button for refreshing the
sheet, only results in the recalculation of the formulas, not the relevant charts. What do i do to solve this problem.... as i would like the formulas as well as the charts to update simultaneously. I can however refresh each individual function present in the workbook seperately - then the values and the relevant chart gets updated
When using excels own functions the formulas as well as
the charts update without any problems.
Any help will be greatly appreciated.
Thanks in advance.

 

[kkawano]

Hi all,

I have run into this same problem. I have done some searches on the knowledgebase though not exhaustive. Anybody find out anything.

Thanks,

Karl

 

[xlbo]

In your UDFs, make sure that application.volatile
is the 1st line in all of them - this means that they should recalc when the worksheet does.
In terms of your "sendkeys code"....why on earth would you bother with sendkeys (which are notoriously unreliable) when you can use
application.calculate Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde