A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
You are welcome. Feel free to come back if meet any question about Excel.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
You are welcome. Feel free to come back if meet any question about Excel.
Got it...Thanks for the quick response.
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.