Updating multiple linked workbooks

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Worksheets 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Linking workbook to multiple worksheets 1
Email Excel Workbook Automatically Daily 3
Is there a way to referance data from or to a closed workbook from 5
Linking workbooks 4
Working with multiple files/workbooks cross linked 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Top