Forum Discussion
rsd43
Mar 01, 2022Copper Contributor
Paste Special link not working on iPad
I have a new iPad Pro. I cannot get the copy-paste-paste special-link feature to work. The copy-paste feature works but cannot link cells. Example - Tab A is a summary of other more detailed tabs. I ...
GRMMing
Jul 26, 2022Copper Contributor
rsd43 Hi. I have the exact same issue with Copy - Paste Special - Paste Link on my iPad when attempting to paste the link from a cell in one tab/worksheet to another tab/worksheet. Works well in Excel on my Mac but not Excel on my iPad. Any ideas anyone? Thanks. GRMMing
- GRMMingJul 26, 2022Copper ContributorHi All.
I have just discovered a workaround, at least something until Microsoft gets its act together.
Try this, in the cell to be linked in Sheet 1, for example. Enter the following. =‘Sheet2’!$E$4. Sheet2 would be the name of the sheet you are linking from and $E$4 would be the cell in the sheet you are linking from. Substitute the actual sheet name and cell number you are using.
Hope this helps someone. GRMMing