<div>
<div class="content wysiwyg-content">
I am coping 3 worksheet into my workbook from another.<br />
the source worksheet from which worksheet are copied has 100s of named ranges. <br />
I need to copy across the named ranges also (which already happens), however the formula in named range is still linked to older workbook.<br />
How to refresh these to point to same sheets, however in new workbook ?
</div>
</div>


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 ?

Excel move worksheet with named range , refresh range

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.