I have a simple two tab (sheet) excel97 file. The first tab contain
report data, the second tab contains summary data
that uses a formula that I created in a standard module.

The situation I have is that when I update the data in the first tab
the data using the formula in the second tab does not autocalculate.

I want to know if there is some procedure I can latch onto and updat
or write a new one from scratch to update the data when the excel fil
is either opened or closed, or after an update occurs
on the first tab. I want to cause the cells in the second tab to b
automatically calculated when a change occurs.

-- Deep Though

--
Message posted from http://www.ExcelForum.com

DeepThought < wrote:
I have a simple two tab (sheet) excel97 file. The first tab contains
report data, the second tab contains summary data
that uses a formula that I created in a standard module.

The situation I have is that when I update the data in the first tab,
the data using the formula in the second tab does not autocalculate.

I want to know if there is some procedure I can latch onto and update
or write a new one from scratch to update the data when the excel file
is either opened or closed, or after an update occurs
on the first tab. I want to cause the cells in the second tab to be
automatically calculated when a change occurs.

Add " Application.Volatile = True " to your user defined function.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Application.Volatile True

worked.

Thanks!


---
Message posted from http://www.ExcelForum.com/