2 ms·
Without good validation (possibly including locked sheets), people will make all fashions of inconsistent entries that “look right enough” but will stymie autom
by sokoloff 4y ago
Without good validation (possibly including locked sheets), people will make all fashions of inconsistent entries that “look right enough” but will stymie automated ingestion.
We had some hellish “use Excel as an interface to ‘real SAP’ process” for budgeting/headcount planning and it was almost utility-free for us as users. Even doing copy/paste would break parts of it, but invisibly to the user in real-time but would fail on import days/weeks later.