link 2 excel spreadsheets together, so when I update 1, the other is updated?

Answer 1

Create the spreadsheet that you need on one of the worksheets. (Or just a couple of cells, or whatever it is that you need). Save the worksheet. This is your 'Source'.

Select the cells that you want to be linked.
Copy.
Go to the second worksheet (the one you want to update automatically when you change your source).
Edit Menu. Paste Special. Paste Link. This is your 'Destination'. Save the worksheet.

Go edit your source. Check your destination.

Be careful... if you edit your destination cells you will break the link.

Good Luck!

Jen

Answer 2

Right click the excel file, and then create a shortcut, copy the shortcut in your desktop or anywhere else you want, that is not with the main file. Try editing the excel file (the shortcut) then check the main file. It will surely be updated as you update the shortcut file..

Give it a try! ;)