Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Copying Worksheets
Why am I no longer able to copy a worksheet within a file by using the right
click copy function? This used to work fine in Excel 2003. When I use it in 2007, I get error messages about a formula or sheet that contains the name '_A' that already exists on the destination worksheet... If you click yes this message goes on and on in some sort of loop that you cannot exit. How can I get the copy worksheet function to work properly? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Copying Worksheets
Hi,
Are you right clicking a sheet tab and trying to copy? If so there may be a range name conflict. If you have range names in the source sheet and you now make a new sheet with the same names, Excel wants to know what you want to do. The reason you didn't get the error message in 2003 is that 2003 automatically changed the scope of the names to local (sheet level). That process is not automatic in 2007. -- If this helps, please click the Yes button Cheers, Shane Devenshire "jej617" wrote: Why am I no longer able to copy a worksheet within a file by using the right click copy function? This used to work fine in Excel 2003. When I use it in 2007, I get error messages about a formula or sheet that contains the name '_A' that already exists on the destination worksheet... If you click yes this message goes on and on in some sort of loop that you cannot exit. How can I get the copy worksheet function to work properly? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Copying Worksheets
I was right clicking on the sheet tab. What do I do to correct the range
name problem in Excel 2007? Why is the process not automatic in the new Exel version? "Shane Devenshire" wrote: Hi, Are you right clicking a sheet tab and trying to copy? If so there may be a range name conflict. If you have range names in the source sheet and you now make a new sheet with the same names, Excel wants to know what you want to do. The reason you didn't get the error message in 2003 is that 2003 automatically changed the scope of the names to local (sheet level). That process is not automatic in 2007. -- If this helps, please click the Yes button Cheers, Shane Devenshire "jej617" wrote: Why am I no longer able to copy a worksheet within a file by using the right click copy function? This used to work fine in Excel 2003. When I use it in 2007, I get error messages about a formula or sheet that contains the name '_A' that already exists on the destination worksheet... If you click yes this message goes on and on in some sort of loop that you cannot exit. How can I get the copy worksheet function to work properly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying charts in excel 2007 | Excel Discussion (Misc queries) | |||
What exactly excel do when copying worksheets? | Excel Discussion (Misc queries) | |||
Copying worksheets into different Excel files | Excel Discussion (Misc queries) | |||
Excel 2003 - Copying formatting through 12 worksheets | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) |