Hi

Might be the wrong forum as it about the interaction of the 365 and its app.


I have a couple of sheets that reference each other.

A typical cell reference would be "c:\[File2.xlsx]Sheet1"$A$23

Which all works fine but when I open the sheet up from the mobile app on an ipad (via dropbox) the references are automatically re written :

"https://www.dropbox.com/var/containers/Bundle/Application/C83651ED-F394-4AC3-A434-A8C24A471018/Excel.app/c:\[File2.xlsx]Sheet1"$A$23

Re opening on the desktop therefore doesn't work as the cells are looking for a file in the cloud which they cant find. I think it may be to do with automatic updating of links.

Any idea how to stop excel being this clever / dense