Update

R

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.
 
T

Tom Hutchins

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

Hope this helps,

Hutch
 
R

robzrob

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

Hope this helps,

Hutch






- Show quoted text -
Click to expand...

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