REF#! how to delete

Hello Erin,

 

Some cell in sheet1 which is called (Financial Report) are referred to a hidden sheet called (Calculations), in the Calculations sheet there are some #REF! errors!

 

The workaround is to unhide the Calculations sheet, select cell B22, hold the fill handle, and then drag it down to cell B39 or just double-click on it.

 

I've done this for you, please find the attached file.

 

Hope that helps