Fix Excel Formulas & Templates

My financial-report templates rely on several nested IF, AND and OR formulas that should pull figures from other sheets in the same workbook, yet the numbers stay frozen when the source data changes. I need someone who can open the file, trace the internal links, correct any reference errors or circular logic, and make sure every total and subtotal refreshes instantly after data entry.

You will be working only inside this one workbook—no external files or databases—so the focus is on sheet-to-sheet connections, range naming, and any settings (calculation mode, table expansion, etc.) that might block recalculation. Once the logic is solid I would like the templates cleaned up: remove any redundant helper columns, lock the finished formulas, and confirm the output matches a short test scenario I will provide.

Deliverables:
• Repaired nested IF/AND/OR formulas that update automatically
• Verified links across sheets with no broken references
• A brief change log so I can follow what was adjusted

I’m on Excel 365, but compatibility with 2019 would be helpful. If you’re comfortable troubleshooting complex conditional formulas and polishing financial report templates, let’s get this wrapped up quickly.