Or (subtitled) why do we get paranoid over having to repair corrupted spreadsheets when we can just replace them?
This is a thread on LinkedIn I woke up to this morning. A bit of additional explanation below.
That methodology needs a little more explanation. And I’ll get to that in a video explainer in the next few days. [TBA] And a little demo model you can try for yourself.
This will contrast (1) the traditional spreadsheet architecture Bill is referring to and (2) the architecture I’m referring to. Perhaps Ejaz can expand on that with PowerQuery.
I’ll be back!