I am not sure how I missed this feature but I did.
It works in Google Sheets.
Here’s the deal.
On occasion when working in Microsoft Excel.
I reference data from other workbooks.
I’m working on a project where we’re collaborating on a set of shared workbooks in Office 365 SharePoint Online.
It just so happens that these workbooks need to reference data in each other.
You would think a feature like this should work.
But it’s a little more complex to pull off then expected.
The problem exists because
Microsoft Excel Online
Microsoft Excel Desktop
and Microsoft SharePoint Online
are missing some pieces to pull things together.
And so the whole thing gets jumbled up.
So now, I’m rethinking how we solve this challenge.
It is frustrating that a feature that I’ve used for so many years in a business local area network doesn’t work in the cloud the way I need to.
Myself and countless others hope that Microsoft figures this out.
It’s a pretty big deal that this functionality doesn’t work.
At least not the way people want it to work.
In the meantime, the workaround is to only reference data inside of the same workbook if we want to keep using Microsoft Excel Online and Microsoft Office SharePoint Online.
Or we could just use Google Sheets.