Forum Discussion
Copy and paste error when posting into new sheet
Good afternoon, I am trying to tidy up my excel doc by copying and pasting data from one sheet to another. However, when I go to save the document I get #REF! error. I am fairly new to ex...
Hi wfricker1
the reason for this is, that your source file contains formulas. When you copy parts of it into a new file, these formulas potentially break.
To avoid this, you can just insert the values instead of the formulas:
Copy the desired source table, goto the new file, do a right click in the first target cell and choose "Paste values":
I'm not sure how to perform a right-click on a Mac, I guess you have to hit the Ctrl-key at the same time, but probably you know it better 😉