I have a series of linked spreadsheets I use every year to generate a series
of reports for a client. I roll the model over and resave the folder under an
updated name every year. The links in the underlying spreadsheets as well as
the links from the charts to PowerPoint have to each be updated. Does anyone
know how to roll-over the folder in a way that updates the links as well so
they don't have to be done by hand? It takes me HOURS to do beaus ethere are
45 reports each with 60 pages which have to be updated page by page.

I would be eternally grateful for any help!

--
EP