Forum Discussion
Insert a link to a cell in other worksheet in Excel Office 365
I have to worksheet A and B. In A I have a Calendar sheet and I want to show in this sheet one date which is in other worksheet. I know how to do this in Desktop Excel bat I don't in Office 365 ...
In Excel for web you may open both files. Ctrl+C the cell with date in one file
Stay on target cell in another file, Ctrl+V, expand Ctrl menu drop-down and click on Paste Links
Apply proper format. Link will be like
You may use HYPERLINK() as well if you use proper link on the file, like
=HYPERLINK("'https://tenant-my.sharepoint.com/personal/name/Documents/[Book8.xlsx]Sheet1'!$A$1", "MyDate" )If open in desktop app, link could be taken in File->Info->Copy path. The only remove ?web=1 at the end of it.
Not sure if above work on all subscriptions, but you may try.