Share via

Paste Link - Update data including new comments

Anonymous
2023-10-13T13:49:42+00:00

I'm using "Paste Link" to tie two worksheets together, but when I add a Comment to the source sheet, it doesn't appear in the subordinate sheet. Is there a way to set that up?

Thx.

Microsoft 365 and Office | Excel | For business | 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 No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2023-10-13T14:38:31+00:00

    You are welcome. Feel free to come back if meet any question about Excel.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-10-13T14:31:34+00:00

    Got it...Thanks for the quick response.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2023-10-13T14:07:47+00:00

    Unfortunately, when using the "Paste Link" feature to tie two worksheets together, any new comments added to the source sheet will not automatically appear in the subordinate sheet. This is because comments are not considered data in Excel and are not included in the link.

    However, you can manually copy and paste the comments from the source sheet to the subordinate sheet if you need them to be included. To do this, simply select the cell with the comment in the source sheet, right-click and select "Copy", then go to the corresponding cell in the subordinate sheet and right-click and select "Paste".

    Alternatively, you can consider using a different method to tie the two worksheets together, such as a macro which may allow for comments to be included.

    Was this answer helpful?

    0 comments No comments