I will try this. I did not create the original data which is why I am
hesitant to make a mass change. Thank you so much.
Chris

"Doug Glancy" wrote:

> Chris,
>
> Can you just do a find and replace in the workbook, replacing "2005" with
> "2006"? Or how about Edit --> Links --> Change Source?
>
> Doug
>
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:46AFE28F-B7B8-4817-94B9-E28BF997BC26@microsoft.com...
> > When changing from 2005-2006 workbooks, is there an easy way to recreate
> > the
> > formulas with a DIFFERENT source name (as the file names will change in
> > 2006)
> > Thanks
>
>
>