Forum Discussion
Microsoft Excel creates CONNECTION LINK after COPY-PASTE instead of the content
Excel creates CONNECTION LINK after COPY-PASTE (CTRL+C & CTRL+V) instead of the cell content (formula) from one opened excel to another opened excel. It does not say anything and silently creates de...
When pasting, you can right click and select Paste Special - values from the paste options and it will paste the values instead of the link (you can also add paste special to the quick access toolbar or hit Ctrl+Alt+V).
Also, you could check the option to 'show paste options button' - after pasting a small drop button will appear next to your cell with paste options.
Thnaks JMB17, However, I agree with Rodemark We're looking for a way to stop this Excel behaviour PERMANENTLY. Linking spreadsheets should be an ADVANCED option that user can turn on if they see a use for it, not the default, that confuses 99% of users. We're not looking for a one at the time solution. How do we TURN THIS OFF, FOREVER?