Solved

Remove Shortcut to Crystal Reports from Excel

Posted on 2004-10-21
362 Views
Last Modified: 2012-05-05

When I installed Crystal Reports 8.5 Developer on my computer, it put a shortcut to Crystal on my Excel toolbar (Version 2000).  The toolbar icon creates a separate row on the toolbar instead of being added to an existing row (where there's plenty of room for another icon), even though it's only 1 icon.  Everytime I open Excel, I remove the icon from the toolbar, but it always comes back.  I even tried to delete the option from the Toolbar Customize screen, but Excel crashes upon closing and the icon is back the next time I open Excel.  Even if I move the icon to one of the other rows, it comes back on it's own row the next time Excel is opened!

It's not causing any problems, but it's annoying.  I would be happy if I can get it to show on the same row as other icons or if I can get rid of it altogether.

Can anyone help?




0
Question by:vrivera22
    7 Comments
     
    LVL 42

    Expert Comment

    by:frodoman
    How are you removing it?  Don't try removing the Crystal icon from the Crystal toolbar - instead just remove the Crystal toolbar itself.

    You should be able to open Excel, rt-click on the toolbar, and uncheck the "Crystal" option.  Then close Excel.

    Your other option is to rt-click on the toolbar, select customize, then uncheck Crystal from the Toolbars tab.

    HTH

    frodoman
    0
     

    Author Comment

    by:vrivera22
    Yep, tried that.  Didn't work.

    I actually do that everytime I open Excel, but the changes I make to the Crystal toolbar always come back!  I have tried everything I can think of (short of uninstalling Crystal, which I won't do).
    0
     
    LVL 42

    Expert Comment

    by:frodoman
    Do you have admin rights on your computer?  When you exit Excel the settings such as toolbars, etc. are written to a registry entry.  This may be a case that you don't have sufficient rights on the system to make this a permanent change?

    frodoman
    0
     

    Author Comment

    by:vrivera22

    I do have admin rights on my computer.  I can make any other changes to the toolbars and it will stick.  It's only the changes to the Crystal toolbar that doesn't stick.  I even tried to delete from the Customize window and Excel crashed with a 'Rintime error 5, Invalid Procedure Call or argument' when I closed it (closed Excel, not the Customize window).


    0
     
    LVL 42

    Accepted Solution

    by:
    You could remove the Crystal add-in completely I suppose.  Tools -> Add In's.  Uncheck Crystal here & I think that'll remove it from the toolbar as well.  You wouldn't be able to use it however unless you re-install the add-in in the future.
    0
     

    Author Comment

    by:vrivera22

    THANK-YOU!!  Removing the Add-in worked!  It's still in the Add-in list, so I can just re-check it if I ever need to use it.

    Thanks!




    0
     
    LVL 42

    Expert Comment

    by:frodoman
    Glad to help - frodoman
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    Lean Six Sigma Project Manager Certification

    There are many schools of thought around successful project management, but few as highly regarded as the Six Sigma and Lean methods. With 37 hours of learning, this training will explain concrete processes for increasing efficiency and limiting wasted time and effort.

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video is in connection to the article "The case of a missing mobile phone (https://www.experts-exchange.com/articles/28474/The-Case-of-a-Missing-Mobile-Phone.html)". It will help one to understand clearly the steps to track a lost android phone.

    860 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now