Share via

Using Paste Link in Excel via SharePoint

Anonymous
2020-03-03T13:20:38+00:00

I can't seem to find how to use the Paste Link option in 2 SharePoint Excel Sheets.  The Paste Special option is not made available when attempting to paste to the 2nd sheet.  Any assistance would be greatly appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-03-03T14:51:01+00:00

    Hi Rene, 

    Based on your description, you want to link the 2 sheets with Specific Paste feature in SharePoint Online, when you change the content of one worksheet, the another sheet will change correspondingly.

    However, due to some limitations of web browser technology, this is feature is not supported in Excel Online, you can refer to this article to know more information about copy and paste in Excel for Web:  Excel for the web

    However, as a workaround, we suggest you open these workbooks in Excel application-> Open -> From SharePoint site-> Open 2 worksheet-> Copy the content you want->Select another workbook-> Paste-> Special paste -> Paste Link. Then it will works.

     

    Appreciate for your understanding.  Please feel free to contact us if you need further help. 

    Regards,

    Ivy

    3 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-03-05T16:03:03+00:00

    Dear Rene,  

    Have you checked my suggestion? 

    Please feel free to contact us if you have further concern. 

    Regards,

    Ivy

    0 comments