Updating multiple linked workbooks

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summarizing multiple workbooks to other multiple workbooks	BK	Microsoft Excel Programming	0	17th May 2010 08:43 PM
Updating workbooks by adding elements of other workbooks?	StargateFan	Microsoft Excel Discussion	0	11th Aug 2008 06:06 AM
Updating Workbooks from multiple links Workbooks	TimJames	Microsoft Excel Worksheet Functions	1	15th Dec 2007 04:34 PM
stupid question re; updating linked workbooks in excel-multiple layers deep	MDBJ	Microsoft Excel Discussion	0	13th Sep 2007 01:34 AM
Linked workbooks will not update without having all workbooks open	=?Utf-8?B?S2F0aGVyaW5l?=	Microsoft Excel Misc	0	26th Feb 2004 06:16 PM