 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Error message with copying sheet to another workbook
I always encounter an error message when i copy a sheet from one workbook to another workbook. The error message is as below: ================ A formula or sheet you want to move or copy contains the name '____123graph_A', which already exists on the destination worksheet. Do you want to use this version of the name? - to use the name as defined in the destination sheet, click Yes - to rename the range referred to the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box. ================ I have tried to click No and enter a new Name, but afterwards i could not find the new Name i gave too. For you info, some of the workbooks were converted from Lotus 123 about 10 years ago. Probably that was why the Name always appears as "______123graph_X" where X can be A, B, C etc. How to get rid of this message? Best regards, Chew The first thing I'd do is to try to find out what that name pointed to and if it was used. Then if I didn't need it, I'd delete it. I'd get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It'll make this kind of detective work much easier. > I always encounter an error message when i copy a sheet from one workbook to > another workbook. [quoted text clipped - 22 lines] > > Chew  SignatureDave Peterson No, the name is neither used and neither can be found in Insert>Name>Define window. So it cant be deleted as it is not there. Thats funny. > The first thing I'd do is to try to find out what that name pointed to and > if it [quoted text clipped - 38 lines] >> >> Chew Some names can be hidden from the user. Did you try the name manager addin? It has the ability to show those hidden names. > No, the name is neither used and neither can be found in Insert>Name>Define > window. So it cant be deleted as it is not there. [quoted text clipped - 46 lines] > > > > Dave Peterson SignatureDave Peterson I do not know that Names can be hidden in Excel. Will try that add-in. tq. But is it possible to manually hidden the Names without using that add in? Regards, > Some names can be hidden from the user. > [quoted text clipped - 59 lines] >> > >> > Dave Peterson You can use a macro to hide or unhide names. But the addin offers so many other features, it's worth the download and installation time. > I do not know that Names can be hidden in Excel. Will try that add-in. tq. > But is it possible to manually hidden the Names without using that add in? [quoted text clipped - 68 lines] > > > > Dave Peterson SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.