I've figured out how to remove the 'link' to the old XLSX file. They all work as intended now. The only other part would be the subfolder structure. Thank you.

EDIT: No I didn't. The macro doesn't work with the files once I turn them into a normal document unfortunately. Still need assistance here.