topic Re: JMP does not show on Microsoft Excel in Discussions

JMP does not show on Microsoft Excel

Kami — Tue, 18 Dec 2018 21:58:43 GMT

I just downloaded the JMP 14 but JMP does not show up on my microsoft excel as it should. As a result, I have to upload my data from excel by going to File --->open ---> upload my excel file ---> Import. How can I get that short cut to have the JMP showing up on excel so I can simply copy my excel data and paste it onto a new window in JMP?

Re: JMP does not show on Microsoft Excel

dave_matthews1 — Wed, 19 Dec 2018 15:43:15 GMT

Kami,

Per the JMP System Requirements, JMP 14's Excel Add-In, will work with Office 2010, 2013 and 2016. We have done some testing with the newer version of Excel and it appears to work correctly with it as well.

That said, there are two possible reasons the Excel Add-In for JMP is missing. First, the add-in registry enteries are corrupt and need to be repaired, or a recent Office update corrupted the registry enteries.

With JMP closed, navigate to Control Panel > Programs & Features.
Find JMP 14 in the installed programs list. Right-click it and select Modify/Change.
This will open the installation options box. Find the Excel Add-In, if it is checked, you will need to uncheck it, click OK and follow the process. Reboot and do the above again, checking it this time.
If it is unchecked, check it and follow the process laid out above.
If this does not fix it, this means something is not working correctly with Excel. Since this is an Excel Add-In and not a JMP Add-In, we rely on Excel to function properly.
In this case, in the Programs & Features, find Office. Right-click and select Modify/Change. When prompted, select the option to do a Repair.
This process has resolved nearly every JMP Excel Add-In issue I have encountered.

If this process does not fix your issue, please put a track in to JMP Technical Support and we will help you resolve the issue. You can do that HERE.

Re: JMP does not show on Microsoft Excel

Dan_Obermiller — Thu, 20 Dec 2018 16:03:25 GMT

Dave had already answered the question, so I removed this reply.

Re: JMP does not show on Microsoft Excel

Cutiehouse — Thu, 20 Feb 2020 18:24:53 GMT

I had the same problem and found solution by following:

On your excel go to

File -> Options -> Add-ins

On the bottom of the menu, you will see "Manage"

Then, select "COM Add-ins" and press Go...

Check both "JMP Profiler Core, from SAS" and "JMP Profiler GUI"

Click "OK."

You will see the add-ins on the excel menu now.

Re: JMP does not show on Microsoft Excel

cwillden — Thu, 28 May 2020 15:14:42 GMT

Thank you! I had JMP Profiler Core checked, but not JMP Profiler GUI. Once I had both checked, the menu appeared for me as well.

Re: JMP does not show on Microsoft Excel

jmorott — Wed, 26 Jun 2024 18:53:21 GMT

Thank you. This helped me get the add in to work again!