I'm trying to link two excel spreadsheets so they update automati

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to link two of my Excel spreadsheets so that when i fill one with
data it automatically updates the other. Can this be done and how?
 
In the destination file type something like this on A1: =[Book1]Sheet1!$A$1
Only one thing. Make sure you have automatic calculation set on your options.
 
You must log in or register to reply here.

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

Excel Spreadsheets keep moving 0
Quick way for monthly linking of Excel sheets 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
User is not prompted to update links when opening spreadsheet 2
if, or 1
Link To File That No Longer Exists 1
Auto Update Linked data 3
Link updates Excel 2007 6

Back
Top