Worksheet Refresh?

[sbremner]

I have two spreadsheet setup, when one gets updated, you open the othe
one to print it. When you open it, it rightly asks if you want t
update the linked information.
However, it doesn't. On ocation it does, and to be honest I can'
figure out why.
So I was wondering if there is any kind of refresh VB code I can inser
into a macro to make sure the info is there?

Can anyone help?

Thanks

Stev

 

[Ken Wright]

You probably have the source workbook open when you don't get the message and
have it closed when you do. If it is closed you get prompted and get to choose
whether it is updated, whereas if it is open it will just update automatically,
without any update prompts.