Sometimes the only way to resolve a cranky pants situation with my kids (or my spreadsheets) is to put on my detective hat.
I go step by step, isolate and test the variables, make small adjustments, and eventually solve the problem.
Cranky pants for my kids usually happens after they’ve been in one place for too long. To resolve, I mix up the environment, the activities/toys, check for a dirty diaper, etc.
Cranky pants for my spreadsheets usually happens after I make one critical change in the data structure, or even the name of a worksheet (if I didn’t set things up to be dynamic enough in advance). To resolve, I check each broken formula, make little adjustments, until it’s all working correctly.
If you’re in the middle of a spreadsheet cranky pants situation of your own, and would like an expert’s detective hat to help you resolve it, send me a message or leave a comment.
I’ll do an audit of your spreadsheet to find the obvious errors, and not so obvious ones, to save you time and headaches, so you can get back to your life.