Forum Discussion

Copper Contributor

Nov 10, 2022

Group of Excel Sheets Referencing Each Other

We have a group of Excel sheets, which reference one another that we track data on per year. When a new year begins, I need to essentially copy and paste these sheets into the new year's folder. Is...

Formulas and Functions

Patrick2788

Silver Contributor

Nov 10, 2022

ppunia

mathetes 's suggestions are excellent.

If you have to proceed with the setup as is, you could use Data | Edit Links | Change Source to speed up the updating a bit.