This should be a problem only if your links include the Folder name. If you
hard code the folder into the link, then you are going to have to change the
name when you change folders.

The likely solution is to remove the folder name. Excel will default to the
folder the file is in. Then when you copy the files to a new folder, they'll
work without change.

Regards,
Fred

"EP" wrote in message
...
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