The 3W1H model breaks down any action or problem into four critical components:
Define a named range with a comment describing the 3W1H attributes. Works for links in formulas.
| | Use a link? | Better alternative | |--------------|----------------|------------------------| | Monthly report pulling from a shared master file (same folder) | ✅ Yes | External reference | | Archiving last year’s data | ❌ No | Paste Values + remove links | | Collaborating via OneDrive/SharePoint | ✅ Yes (but use =HYPERLINK to web versions) | Avoid C:\Users\... absolute paths | | Building a model for a client who will move the folder | ❌ No | Consolidate all data into one workbook |
The 3W1H model breaks down any action or problem into four critical components:
Define a named range with a comment describing the 3W1H attributes. Works for links in formulas.
| | Use a link? | Better alternative | |--------------|----------------|------------------------| | Monthly report pulling from a shared master file (same folder) | ✅ Yes | External reference | | Archiving last year’s data | ❌ No | Paste Values + remove links | | Collaborating via OneDrive/SharePoint | ✅ Yes (but use =HYPERLINK to web versions) | Avoid C:\Users\... absolute paths | | Building a model for a client who will move the folder | ❌ No | Consolidate all data into one workbook |
