Forum Discussion
Master Sheet
- Mar 23, 2021
PMcD0609 Your sheet contains circular references. Cells that contain formulae that include the cell where the formula is written. Go to the "Formulas" ribbon, Error checking and then "Circular References" until you have corrected all of them. Did that for you in the attached sheet, but everything still comes out to zero as it seems that all of your cells in the master sheet link to cells with zero values. But perhaps I'm not following the logic of your schedules.
PMcD0609 Your sheet contains circular references. Cells that contain formulae that include the cell where the formula is written. Go to the "Formulas" ribbon, Error checking and then "Circular References" until you have corrected all of them. Did that for you in the attached sheet, but everything still comes out to zero as it seems that all of your cells in the master sheet link to cells with zero values. But perhaps I'm not following the logic of your schedules.
- PMcD0609Mar 23, 2021Copper ContributorThank you so very much!!!!! I have been racking my brain (which is getting older by the minute).
You are the best. I will do my best to pay it forward today and make someone's day easier!!!- Riny_van_EekelenMar 23, 2021Platinum Contributor
PMcD0609 Glad it worked out for you!