hOW CAN LINKED FILE DATA CAN BE UPDATED AT ONCE
 

Hi friend

I have a workbook, where some of the data are linked with another files.
Every time when those linked files have changes, data in my work book won't
update until I go to that field and display the formula and hit enter to make
it updated. Is there any quicker way to do it ?

Thanks for the assistance.

Close/reopen the file with the links, respond "yes" to update linked
information.
Or, with the linked file already open, open the updated file (the new data
will update immediately) and close the updated file.


"Excel User" wrote:

Hi friend

I have a workbook, where some of the data are linked with another files.
Every time when those linked files have changes, data in my work book won't
update until I go to that field and display the formula and hit enter to make
it updated. Is there any quicker way to do it ?

Thanks for the assistance.

Edit|Links|Update values

Is another way.



Excel User wrote:

Hi friend

I have a workbook, where some of the data are linked with another files.
Every time when those linked files have changes, data in my work book won't
update until I go to that field and display the formula and hit enter to make
it updated. Is there any quicker way to do it ?

Thanks for the assistance.

--

Dave Peterson