Update

  • Thread starter Thread starter robzrob
  • Start date Start date
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.
 
Try selecting Edit >> Links... Make sure the correct source is selected,
then click 'Update Values'.

Hope this helps,

Hutch
 
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.
 
Back
Top