Excel move worksheet with named range , refresh range
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 ?