I have a master spreadsheet with external links to other spreadsheets. The master spreadsheet is shared with several users including some external users. The users within my organisation have no issues to enable the external links and update the values, however the external users are not able to enable the links. Instead they see this message and the values remain the same:
"Links Disabled: Links to external workbooks are not supported and have been disabled."
I have further tested the above by sharing the master spreadsheet with a (free) Microsoft outlook account and I was actually able to enable the external links.
Is it possible that non-Microsoft accounts are not permitted to enable external links in Excel Online? Does anyone know a workaround for this?