Forum Discussion

wfricker1's avatar
wfricker1
Copper Contributor
May 02, 2022

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 excel and cannot figure out how to resolve the issue,

 

Any tips would be appreciated

Excel
Excel on Mac
  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    May 03, 2022

    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 😉

Resources