Excel Link - 3w1h Format In

| Error | Likely cause | Solution | |-------|--------------|----------| | #REF! | A linked cell/row was deleted | Restore from backup or relink | | #N/A | XLOOKUP can’t find the Task ID | Check for extra spaces using TRIM() | | #NAME? | Typo in table name (tbl3W1H) | Go to Formulas > Name Manager to verify | | #VALUE! | Date linked to a text cell | Use =DATEVALUE() before linking |

| What (Issue) | Who (Owner) | When (Date) | How (Action) | |--------------|-------------|-------------|---------------| | Server down | IT Team | 05/15/2026 | Reboot & patch | 3w1h format in excel link

External links (e.g., ='[Q2 Plan.xlsx]3W1H'!$C$4 ) break if the source file moves or is renamed. Prefer internal workbook links. Part 7: Troubleshooting Broken 3W1H Excel Links You see #REF! or #N/A . Here’s the fix: | Error | Likely cause | Solution |

=HYPERLINK("#'Master_3W1H'!A"&ROW(A2), "View Task "&A2) | Date linked to a text cell |

Name the file: 3W1H_Project_Management_LINKED.xlsx

Excel spreadsheet showing 3W1H columns (What, Who, When, How) with blue hyperlink arrows connecting master data to a dashboard.

– Columns A:E (3W1H + ID) Sheet2: Dashboard – Contains FILTER + HYPERLINK as shown above Sheet3: How_Details – Linked from Master’s "How" column (use = Master!E2 )