Excel

I have a spreadsheet with monthly revenue, costs and headcount through June and a renewal pricing sheet attached. Send the updated revenue worksheet to Priya in procurement and to Miguel, the finance director, for e-signature, in that order, with a firm Friday deadline — but first check formulas, confirm totals match the summary tab and that the renewal column is populated for all accounts.

Before I send this workbook to the client's procurement team, make approval obvious: surface the net savings number at the top, pull pricing lines into a single view, highlight any negative-margin rows and flag rows missing contract end dates that will make a reviewer hesitate.

I corrected a copy-paste in the cost column and the summary total dropped by 12,000. Priya expects accurate monthly run-rate before Friday and Miguel will lock numbers. I don't know whether the drop is a real correction, a missing sheet, or an accidental range change. What's the most likely cause and the fastest reliable check so I can tell them the truth?

Every quarter I spend a day chasing phantom discrepancies: formulas broken by pasting, hidden sheets with old assumptions, and version drift between analysts. I lose credibility and late approvals. What habit should I change so summaries are stable and I stop firefighting an hour before sign-off?