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

W

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to copy a worksheet containing named ranges to anotherworksheet 1
Excel 2007 Move or Copy worksheet 2
Stop named ranges from copying into other workbooks 1
Copying Named Range 5
Naming Areas on Worksheet (Excel 2002) 5
How do I merge/combine different workbooks with different sheets 2
Sending a single worksheet as an attachment 3
Copying A Worksheet From Each Open Workbook to an new Workbook 1

Top