Solved

Remote Microsoft Excel Add-in

Posted on 2013-05-30
5
851 Views
Last Modified: 2013-07-06
I have an "unsupported" add-in that was loaded to a users computer from Kareo.  When I say unsupported that means that they only support it if the add-in works.

I was able to do a test install onto a system that is running same OS and Save version of Office.

Here is my dilemma --

First it was installed on a system (os / version same as above) incorrectly.

so the add-in show's up in Add-Ins on Excel.  When we try to execute any of the add-in menu driven commands it fails says cannot find kareo%20...blah blah blah.xls maybe is has been removed or deleted.

So on the test system the add-in was added successfully the correct way, and it works.  On the system with the problem we attempted to re-add the add-in from a general location and went through the setup and all seemed to work the first time.

Now after closing excel and re-opening the add-in appears to be calling the first add-in that was loaded incorrectly.  We get the same error message that we received above.  So my thoughts are somehow I need to completely remove that add-in from previous install ...

I have no references to it in the registry
the only option on excel add-ins is to uncheck the box, but it is the same name as the new add-in and unchecking the box does nothing, still have the add-in menu on the add-in toolbar.

How can I remove this add-in?  

also to get the new add-in to work I had to modify the macros or code from references to DOMDocument to DOMDocument60 (adding 60 to any parts of the code that failed.)  This works well on my test system...  

PS.. I am not a coder so don't understand it 100%

Any help is appreciated.

If my description of problem is bad or incomplete I apologize.  Please feel free to ask me to clarify anything.  I have attached a picture of the error and the menu that show's up in both working and non-working deployment (it's the same in either).
Please help.
kareoError.PNG
kareomenu.PNG
kareomenu2.PNG
0
Comment
Question by:halejr1
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Faustulus
ID: 39209771
To remove an add-in from your computer it may be best to delete the file. There is a default location for add-ins. On Excel 2010 it might be C:\Users\[UserName]\AppData\Roaming\Microsoft\Addins. If you don't run Excel 2010 or you don't file your workbook there you can search for the file name on your C-drive. You can also simply open the list of Addins installed on your computer (Developer tab -> Addins), click Browse and Excel will automatically open the default file location.
After you delete the workbook the Add-in will still be listed. Restart Excel. If Excel tries to load it you will be informed that it wasn't found. If not, load it manually from the Add-ins list, where it still appears. Excel will ask you if you wish to delete it. Click yes, and it will be finally gone.
You can use the reverse process to install an Add-in. Place it in the default file location (with the correct extension, xla*), Developer tab -> Addins -> Browse, and select it.
The most important thing is to remember to restart Excel after deleting addin workbooks in the directory before placing files there with the same name, even if the extension is different.
I hope this helps you solve the problem.
0
 
LVL 8

Author Comment

by:halejr1
ID: 39209881
thank you I will try this tonight and if success award you points.
0
 
LVL 8

Author Comment

by:halejr1
ID: 39220374
did not resolve issue.  I have deleted all references to the file including shortcuts... gone as far as searching the registry, etc.  

System still show's the add-in and when selected get the associated error message.

Any other thoughts or idea's?

Thanks.
0
 
LVL 14

Accepted Solution

by:
Faustulus earned 500 total points
ID: 39220567
Did you find the add-in file?
It should be in C:\Users\[UserName]\AppData\Roaming\Microsoft\Addins. There is no need to go into the registry.
Have you located the default file location your Excel setup is using? It should be at the above address but, since you have a problem, it will be better to check it in the way I told you last time:-
You can also simply open the list of Addins installed on your computer (Developer tab -> Addins), click Browse and Excel will automatically open the default file location.
The problem will not go away unless you find and delete the file and then restart Excel.
0
 
LVL 8

Author Closing Comment

by:halejr1
ID: 39304200
this did not solve my issue but was very good advice.  I had to create a new profile and all was good.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

808 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