Forum Discussion

rsd43's avatar
rsd43
Copper Contributor
Mar 01, 2022

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 have column total in tab C and I want that total to automatically transfer and update to tab A. I cannot link these two cells that are in different tabs.

I could easily do this with my Apple laptop, but cannot get it to work on the new iPad.

 

Formulas and Functions

2 Replies

  • GRMMing's avatar
    GRMMing
    Copper Contributor
    Jul 26, 2022

    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

    • GRMMing's avatar
      GRMMing
      Copper Contributor
      Jul 26, 2022
      Hi 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

Resources