Paste Links to Copied Cells Not Working

SYSPK ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

When I copy cells from one sheet and paste them onto another, I right-click and want to use the Paste Special > Links to Copied Cells option, but it's often grayed out. Not sure what I'm doing wrong.

The info from the other sheet has been saved. The information has been highlighted and copied. I am also selecting the exact number of cells that I want to copy to in the new sheet.

I have 1 destination sheet and many source sheets that I want to pull information from. What's interesting is that using other source sheets, I have successfully pasted this way on the same destination sheet. Sometimes it works, sometimes it doesn't.

Any advice?


Thank you