How To Stop Excel Copying Named Functions When A Worksheet Is Copied?

[Wayne]

I have a workbook that contains several worksheets that have named
functions. If I copy one of these worksheets into another workbook by
right clicking the worksheet's tab and using the "Move or Copy"
functionality, all of the named functions belonging to the entire
workbook are copied into the second workbook. How can I stop Excel
copying the named functions to the new workbook?

 

[CurlyDave]

Could you explain more on the Named Functions?

 

[Joerg Mochikun]

....and it copies named ranges, right? I think that this is the behaviour you
would expect when you copy a whole sheet, otherwise references to named
ranges or formulas wouldn't work anymore on the copied sheet.

To copy just the contents and formats, select all cells (not the sheet tab)
and copy them to a newly added sheet in your target workbook.

Joerg