Reading data in onther Excel document

  • Thread starter Thread starter Ernest
  • Start date Start date
E

Ernest

How do I read data in another opened excel document (in a certain sheet
without activating it
 
By "read" do you mean link it into the active workbook? Use a link formula:

='[Other Book.xls]Sheet1'!$A$1
 
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

Issue is facing on Word 2016 -{EMBEDED Excel.Sheet.12} 0
using the =page! feature to transpose a row to column 0
Excel How to Fix Damaged Excel File That Won't Open? 3
automatic move row from sheet to another 1
Cannot get previous data after ctrl + w 0
Excel 2007 Chart creation 1
Excel Lost data when opening Excel 2003 spreadsheet in Excel 2007 0
Merging Excel Sheet with Excel Sheet (Just like in MS Word!) 3

Back
Top