Update

[robzrob]

Is there any way to update a workbook (which is getting data from
another workbook) without shutting it down, opening it again and
clicking 'Yes' to the update question in the message box every time?

Tried F9, doesn't seem to work.

 

[Tom Hutchins]

Try selecting Edit >> Links... Make sure the correct source is selected,
then click 'Update Values'.

Hope this helps,

Hutch

 

[robzrob]

Try selecting Edit >> Links...  Make sure the correct source is selected,
then click 'Update Values'.

Hope this helps,

Hutch






- Show quoted text -

Thanks, Hutch, I've put it in a macro. Perfect.