ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Updating multiple linked workbooks (https://www.excelbanter.com/new-users-excel/92983-updating-multiple-linked-workbooks.html)

dk

Updating multiple linked workbooks
 
We have several workbooks which 1 gets data from other etc. is there anyway
to have a one step to update all at once

JLatham

Updating multiple linked workbooks
 
Not in the usual sense. Generally you can only update from one 'level' of
linked workbooks unless all are open.

What you can do is open all related workbooks and then use
File | Save Workspace
to quickly have access to all of those needed workbooks. See the Help topic
on Workspace for more information.

"dk" wrote:

We have several workbooks which 1 gets data from other etc. is there anyway
to have a one step to update all at once



All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com