Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Stop Excel Copying Named Functions When A Worksheet IsCopied?
Could you explain more on the Named Functions?
|
#3
Posted to microsoft.public.excel.worksheet.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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying data to a named column on a different worksheet | Excel Discussion (Misc queries) | |||
Stop Excel from Formatting Copied Data from Outlook | Excel Discussion (Misc queries) | |||
Stop named ranges from copying into other workbooks | Excel Worksheet Functions | |||
How do I stop an Excel file from being copied | Excel Discussion (Misc queries) | |||
Named references broken on copied worksheet | Excel Discussion (Misc queries) |