Linking Excel Files

S

sdavis

How to link two or more excel files? I want to make changes in one file and
have the changes updated on the other file.
 
S

Sean Timmons

Are you saying you want workbook A to be edited and workbook B to receive
results? Or, do want it set up where one can edit either workbook and have
the other capture the results?

For the first, you can just have both workbooks open, then in workbook B
type = and click the cell in workbook A you want it update with.

If B, if you want both to be the same exact file, just right click on the
file and make a shortcut.

If you want them to be two aboslutely different workbooks, you can check
with the programming section because that's not a worksheet function.
 

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

Top