COPY NAMED FORMULA

[Robert H]

from a workbook I need to copy two workseets and associated named
formulas to another workbook

the sheets copy over fine using the normal method. However in the new
workbook the named formulas refer back to the original workbook.

How can I transfer the named formulas to the new workbook so it is
self suporting?

thanks
Robert

 

[Don Guillett]

Try
edit>links>change link

 

[Robert H]

Im using 2007 so the steps to get there are different hit the rournd
windows thing then Prepare - Edit Links to files.

On in the edit links dialog, one link was present. I changed the
source to the active file thinking that that would cover all the Named
Formulas. However, the formulas did not change. So I dont know what
that link was to. this was a practice file. Inm y real file the
method I ended up using was to edit each effected formula in the name
manager. Tedious but it worked.

Thanks