Lock a sheet to archive data
I have a sheet in which we capture each users time on our projects. I will call it the Parent sheet. Each year do a Save As New to start the sheet fresh for the new year. This Parent sheet links to several other sheets that continually change over time. I don't need to track the changes in the linked sheets but I do want to archive each years Parent sheet. Is there a way to archive a sheet so that it keeps the existing data but essentially removes the links to the other sheets so that when we make changes to these linked sheets they don't flow into the archived sheet? Thank you for any assistance.