Home

Excel online external workbook cell reference

alhambra
Occasional Contributor

In desktop Excel we can reference a cell from another work book by the following type of reference
'"filepath"\[two.xlsx]Tabone'Sheet1'!C2

 

I need to do the same thing on Excel Online residing in SharePoint., both 2016

 

I have read many threads which indicate you can, but inevitably the person who answers can't see the word 'ONLINE' - so is there a date when this will be fixed?

This is one of the features that is keeping my multinational company switching away from Google Suite.

 

Can I get a date on a fix?