Is calculation set to automatic? (tools=Options=Calculation tab) Are both
workbooks open when you make the change?

Volatile only affects the function which contains the volatile statement -
that function is recalculated anytime there is a calculation performed. It
doesn't affect other cells, but any cell dependent on that cell (with the
volatile function) should get updated if calculation is set to automatic.

--
Regards,
Tom Ogilvy

"DRK" wrote in message
...
I have a two workbooks which are linked together. One field in the master
workbook has a TRUE/FALSE field. Through a link to a similar field on the
slave workbook, it controls which set of values are being used. The values
are either Financed or NonFinanced.

When I run a macro to print either set of values, the macro sets the value
in the master to either TRUE or FALSE. Then it prints. The print always
seems
to be one behind - that even though the valuie was set to TRUE by the
macro,
the calculated values are for the FALSE setting. And vice-versa if the
macro
sets it to false - it prints the TRUE version.

If you run it the second time - without resetting the TRUE/FALSE, it's
fine.

I've tried applying Application.Volatile TRUE but it doesn't seeem to be
helping.

What else can I do to get the workbooks in synch?
--
DRK