Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"_Fill" and "_Key1" is contained in the worksheet I want to copy..
We are trying to copy a worksheet in Excel and we get the notice that the
sheet we are trying to copy contains the name '_Fill' and '_Key1' which already exists on the destination worksheet. There are no named ranges, no set print ranges, no macros. We have no idea what these refer to. What are they? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"_Fill" and "_Key1" is contained in the worksheet I want to copy..
I don't think that these are built-in names that excel uses. (At least through
xl2003.) But names can be hidden -- even names that refer to ranges. Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: NameManager.Zip from http://www.oaltd.co.uk/mvp It's the best tool I've seen for working with names. You'll be able to see names (hidden or visible) and even hide/unhide them. CWP wrote: We are trying to copy a worksheet in Excel and we get the notice that the sheet we are trying to copy contains the name '_Fill' and '_Key1' which already exists on the destination worksheet. There are no named ranges, no set print ranges, no macros. We have no idea what these refer to. What are they? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |