I have created a folder containing 15 sheets with various links to reference sheets (outside of this folder) and datameshing. The idea is that I can copy the folder, change a cell reference (location) and the new folder will update with the reference data for that location.
I've "saved as new" the folder and gotten an error that advises that only 7 of the 15 files have saved into the new folder.
Has anybody else experienced this, are there solutions.
I have just under 30 locations and don't want to have to build 30 folders from start to finish.
Thanks.