"Save as New" folder not saving cross-sheet column references

Options

Good afternoon,

Thank you in advance for your help, time and attention.

I created a workspace with folders that contain template I need to save as new annually. I cannot save as new the workspace because there are too many files in it. When I did that today, the cross-sheet references in all of the sheets within the folder did not save the reference. When saving as new (please see the attach picture) I made sure to have these sheet reference the newly created master sheet. I've attached a photo of the columns now giving me an error. Help please? This will take HOURS if not days to correct. TIA



Answers