Worksheet Copy to another will lost the name of named cell?

Jun 25, 2014 at 12:38 AM
There have two workbook and
workbookA has some named cell in sheet1 and when I copy to the sheet1 to another workbook
then I found the name of the named cell will be lost in the WorkbookB.

I'm not sure this is the supposed work but I think mybe should save their named will be better. :-D
Jul 9, 2014 at 4:51 PM
It copies the named ranges in the worksheet but it doesn't copy the ones with workbook scope. The reason is that ClosedXML can't guarantee that the referenced sheets will be available after the copy. If you know they will be then you have to copy the named ranges yourself. Excel deals with this by referencing the actual source file the worksheet was copied from.

See our other thread: