Linking formulas from seperate workbook

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

Guest

I am using Microsoft Office Excel 2003. Im not sure whether this is possible
at all, but is there a way to make a formula where you extract data from
seperate workbooks? I know you can do this using seperate worksheets, but
unsure in regards to workbooks.
 
Yes, but you can get into difficulties if the other workbooks aren't open
when you try to update values.
 

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

Exporting data 3
Copy/ move selected data from workbooks to seperate worksheets or workbooks 1
Splitting data from sheets into seperate workbooks based on formul 1
Hyperlink to cell in separate workbook 3
VLOOKUP - Referencing seperate workbook getting #N/A erros 2
calendar/schedule 1
matching & combining data from seperate worksheets 2
can EXACT search for text in an entire spreadsheet? 3

Back
Top