How To Stop Excel Copying Named Functions When A Worksheet Is Copied?
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? |
How To Stop Excel Copying Named Functions When A Worksheet IsCopied?
Could you explain more on the Named Functions?
|
How To Stop Excel Copying Named Functions When A Worksheet Is Copied?
....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 "Wayne" wrote in message ... 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? |
All times are GMT +1. The time now is 05:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com