How can I change an equation to reference another workbook?

[Teleporpoise]

I have this equation in my document that references a sheet in the same workbook

=OFFSET(INDIRECT("feature[#headers]"),MATCH(I7,INDIRECT("feature[op '#]"),0),1,COUNTIF(INDIRECT("feature[op '#]"),I7),1)

But the data it is referencing is also referenced by multiple other workbooks. At the moment every workbook has a copy of that data and references its copy, but this is not a good longterm solution. Can I have this equation referenced from a separate workbook?

 

[DSCfromCFA]

G'day Teleporpoise,

I'm not sure which way your referenceing is going, however, referencing another workbook is done in the same manner as referencing another cell, or another worksheet - when you get to the reference part of the equation, you simply go to what you wish to reference and click on either the cell or range of cells as required, and Excel will put the link in the correct syntax and add the selected cell address(es).

The link can then be monitored from the Data Ribbon in the Connections section (located almost directly under the Data tab).

Regards

shane

 

[Teleporpoise]

Thanks Shane, I actually had to use Power Query for what I wanted in the end.