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

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