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 https://support.office.com/en-us/article/how-to-correct-a-ref-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be errors!

 

The workaround is to unhide the Calculations sheet, select cell B22, hold the https://support.office.com/en-us/article/copy-a-formula-by-dragging-the-fill-handle-in-excel-2016-for-mac-dd928259-622b-473f-9a33-83aa1a63e218, 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