Forum Discussion
Microsoft Excel creates CONNECTION LINK after COPY-PASTE instead of the content
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.
JMB17 But that only pastes one thing at a time and it creates more situations where excel simply acts differently on right click - happens to me all the time.
I need to work with tables (rows, columns) the efficient way, not the opposite.
I thank you for your will to help, but this is not a solution, just an emergency move. CTRL+V should simply paste the content (whether it is formatted, with formulas or not), but definitelly NOT a LINK to another file!