Update
 

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.

Update
 

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

Hope this helps,

Hutch

"robzrob" wrote:

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.

Update
 

On Jun 16, 9:30*pm, Tom Hutchins
wrote:
Try selecting Edit Links... *Make sure the correct source is selected,
then click 'Update Values'.

Hope this helps,

Hutch



"robzrob" wrote:
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.- Hide quoted text -

- Show quoted text -

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