Most companies, behind their pretty façade, are operating on the brink of disaster. I see it all the time. People are emailing each other different broken versions of the same workbook, all saved and modified in different ways, all with broken links and inconsistent data. Oftentimes when something changes, there are 10-20 other workbooks at the company that are no longer “correct”. Someone then has to open each workbook to fix them.
Yes, there was that one girl who linked several workbooks to each other with VLOOKUPS. But of course she has left the company and we’re not sure where those files are now. Also, why are there so many formulas that say #N/A? And what about this random hidden section? Where did these numbers come from? Were they typed? Are they correct?