Excel move worksheet with named range , refresh range

cynx used Ask the Experts™
I am coping 3 worksheet into my workbook from another.
the source worksheet from which worksheet are copied has 100s of named ranges.
I need to copy across the named ranges also (which already happens), however the formula in named range is still linked to older workbook.
How to refresh these to point to same sheets, however in new workbook ?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try moving instead of copying.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial