Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Name conflicts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter - 01 Apr 2008 04:58 GMT
Below email was posted before. I have lost the link that direct me to the
add-in manager that can unhide hidden name.
Can anyone advise me again.

TQ

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,
Bob Phillips - 01 Apr 2008 08:41 GMT
Jan Karel Pieterse has a utility designed to improve working with defined
names.
It is a free add-in, and you can get it at
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Below email was posted before. I have lost the link that direct me to the
> add-in manager that can unhide hidden name.
[quoted text clipped - 27 lines]
>
> Best regards,
 
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.