Cells Not Linking
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. It worked for the first 20 cells and now it will not. Sometimes I can select 10 cells and it will only link 9 of them..
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.
Sometimes it works, sometimes it doesn't.