Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel - Copy Sheets Problem (Excel 2000 SP2)

    I have an Excel workbook with a significant number of sheets. I have one sheet that has defined names, I am trying to create a copy of this sheet. When I do so I am prompted with the following

    " A formula or sheet you want to move or copy contains the name 'wrn.print', which already exists on the detination worksheet. Do you want to use this version of the name? To use the name as defined in the destination sheet select Yes To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Names Conflict dialog box"

    If I select Yes it continues if I select NO it prompts me to enter a different name.

    I am unable to locate anywhere in the sheet where the formula or name 'wrn.print' is lcoated, I presume this is a defined name. Some questions

    Is it a defined name?
    If it is how can I locate the defined name?
    What is the message trying to tell me?
    How can I amend the workbook so that the worksheet copy does not prompt me with the above?

    All help much appreciated

    Regards

    John

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    With the sheet that you're trying to copy active, from the menu bar select Insert | Name | Define (or press Ctrl + F3). Do you see wrn.print listed? From your description, I would think you must. It is also probably a worksheet level name, maybe defined in all your sheets(?)

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Hi Colin,

    wrn.print is not listed. How can I establish if it is defined in all sheets?

    Regards

    John

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Oh. Then I'm not sure what to suggest. WorkBOOK level names are valid in all sheets, but from your description I was guessing that each sheet had wrn.print as a workSHEET level name. Not so, apparently.
    Maybe somebody else has a suggestion? Would anybody know if it could be related to Excel4 macros?

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Hi Cecil,

    I have done this, still no joy, I think this is because it is not a link rather a defined name of some sort.

    Regards

    John

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    I would guess that this is a defined print range still there from some previous user/operation. You might try the Edit Menu/Find/"wrn.print" and see if you can find where in the sheet the reference exists. You also might look at Views/Custom Views and see if the "wrn.print" is listed as a custom view.

  7. #7
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Have you hit <F3> and selected the "Paste List" command button on the lower right. If so, does the name appear in the list?

    I played with v4 macros a bit, and I did not see where there names behaved any differently than any other range name.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Range name could be hidden.
    Go the Immediate screen of VB (alt-F11, ctrl-G) and enter:
    names("wrn.print").visible = True
    to "unhide" it

    Enter:
    ? range("wrn.print").Address
    to get its address (you have access to alot of other methods and properties)

    Entering in:
    names("wrn.print).delete
    Should delete the name (if that is what you want to do)

    Steve

  9. #9
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Hi Mike,

    I have tried this too, again no joy, I have also tried F3 and the name does not appear in the paste list. I'm at my wits end to figure out where this wrn.print is located.

    Regards

    John

  10. #10
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    In the formula bar, is it in the drop down list? If not, Steve's solution might be the best.

  11. #11
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Hi Steve,

    No joy, sorry. What I have been able to do using a utility i downloaded is extract all the defined names in the workbook below is an example of what is returned

    wrn.Print. ={#N/A,#N/A,FALSE,"Assumps";#N/A,#N/A,FALSE,"Data";#N/A,#N/A,FALSE,"Data (2)";#N/A,#N/A,FALSE,"AcqyrP&L";#N/A,#N/A,FALSE,"Acq+1P&L";#N/A,#N/A,FALSE,"Acq+2P&L";#N/A,#N/A,FALSE,"Cashflow";#N/A,#N/A,FALSE,"BalSheet";#N/A,#N/A,FALSE,"Bidder";#N/A,#N/A,FALSE,"Tar

  12. #12
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Strangely strange. Presumably every fourth parameter (in quotes) is a sheet name from the workbook? Not sure if knowing that gets us anywhere, though. If it's not related to an earlier version of Excel, maybe the name(s) were created by an add-in? Do you have any add-ins loaded (apart from the Bill Manville utility)? Again, though, I don't know if that's going to help in figuring out how to delete them! Would you be able to post the workbook (maybe with a reduced number of sheets to cut down on the size)?

  13. #13
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Here it is!

    Open a new workbook. Go to View, Report Manager. Add a Report. Copy the Sheet. In my case, I used the name test and I received the message A formula or sheet contains the name wrn.Test.

    The solution, use the Delete command button in the report manager.

  14. #14
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    Is that an add-in you have installed? I'm not familiar with Report Manager so I assume it's not a built-in Excel feature.
    Regards,
    Rory

    Microsoft MVP - Excel

  15. #15
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel - Copy Sheets Problem (Excel 2000 SP2)

    It is one of the standard addins that ship with excel.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •