Forum Discussion
#REF!
I have (2) sheets in one workbook. The first sheets acts as a summary of the second sheet. I have formulas set up on sheet 1 to gather data from the 2nd sheet. These formulas are basic (=Sheet2!A1...
Moving the cell you cut it and paste over another cell, that causes #REF error How to correct a #REF! error - Microsoft Support. Formatting doesn't matter.
If copy and paste (or drag holding Ctrl) it shall work.