It’s hard for me to see the full formulas from what is provided in this thread so I can’t tell you exactly what to replace but, essentially, if you see a reference in a formula that looks something like this:
'\\QNAP3502\Personal\...Tracker_v1.62.xlsx'!Categories[#Data]
It needs to be reduced to this (with no filename and path prefix):
Categories[#Data]
When you do the Edit Links workflow, essentially we are just trying to more-automatically do this find and replace operation to remove the external-file references from the cell references.
Make sense?