May 02 2022 08:39 AM
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 excel and cannot figure out how to resolve the issue,
Any tips would be appreciated
May 03 2022 04:54 AM - edited May 03 2022 04:56 AM
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 ;)