Excel Online - How to reference ranges and tables in different workbooks?

Copper Contributor

Testing office online - cannot reference a range or table in different workbook in formulas

Is this possible in online/web version?

How?

Thanks

4 Replies

@Felipe_mx01 

- select range/table in one workbook

- copy it

- got to another workbook

- right click on cell where to paste and select

image.png

- enable content

@Felipe_mx01 

 

 

As a variant:

Create a named range within the workbook you will be referencing then use the named range as a reference within the workbook you are using the formulas in

@Yea_So 

Did I miss something, Excel Online supports naming?

@Sergei Baklan 

 

Not that I am aware of, but op was asking if possible in online version, but didn't mention that they don't have excel desktop and only has online version. So just in case they have desktop version, then they can setup referencing the excel file using desktop version but when they open the file using online version I assume the results to the setup named range reference still works. Correct me if I have an incorrect assumption.