Excel VBA Calculate Problem

  • Thread starter Thread starter DeepThought
  • Start date Start date
D

DeepThought

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
 
DeepThought said:
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.
Click to expand...

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

Regards,
 
Back
Top