Excel not refreshing data for User Defined Functions
 

Hi,

I have a problem where i created a User Defined Function, and call it
from many cells on similar sheets, ie in C1:C10 of Sheets 1,2 and 3.
The data however doesn't get updated when the cells the function looks
at are updated.
Adding Application.volatile to the start of the function fixes this,
but now when I swap between sheets the cells C1:C10 have the same
values as those from the previous sheet I was on. It is not until I
double click on the cell and press enter does the correct value
display, but changing to the first sheet (or any other sheet) repeats
this problem.

The closest I could find to this problem is he
http://groups.google.com.au/group/mi...85abb06a8da8f?

There is no mention of the sheet changing issue though, and their
solution didn't work for me.
I'm using Excel 97 SR-2

Thanks

Excel not refreshing data for User Defined Functions
 

Can you post your code. It's probably something to do with the sheet
reference.

--
Robin Hammond
www.enhanceddatasystems.com


wrote in message
ps.com...
Hi,

I have a problem where i created a User Defined Function, and call it
from many cells on similar sheets, ie in C1:C10 of Sheets 1,2 and 3.
The data however doesn't get updated when the cells the function looks
at are updated.
Adding Application.volatile to the start of the function fixes this,
but now when I swap between sheets the cells C1:C10 have the same
values as those from the previous sheet I was on. It is not until I
double click on the cell and press enter does the correct value
display, but changing to the first sheet (or any other sheet) repeats
this problem.

The closest I could find to this problem is he
http://groups.google.com.au/group/mi...85abb06a8da8f?

There is no mention of the sheet changing issue though, and their
solution didn't work for me.
I'm using Excel 97 SR-2

Thanks