?
Solved

MS Office Addin works in Excel but not Word

Posted on 2013-05-15
9
Medium Priority
?
5,231 Views
Last Modified: 2013-05-22
Hello,

I have an odd situation.  I am using a Microsoft Office Addin called 'BI Publisher' which is an Oracle product.  It is designed to work in Excel and Word.

I am using Office 2010 on a 64 bit Win 7 SP1 machine.  The addin installed correctly and appears on the ribbon in both Excel and Word.  We are using it in Word.  It was working for me, but it has stopped working.  It still appears in the ribbon and the icons show active, however, when you click an icon nothing happens.  When you go to Excel, it works.

I have uninstalled and reinstalled the addin.  I have used 'Programs and Features' to repair Office.  I looked at the Event Viewer logs.  I am having no luck.

I hadn't made any intentional changes to the machine and it worked one day and not the next.

Any ideas on what the difference would be between Word and Excel using the same Addin?  I am a developer, but not familiar with developing in Office.  Is there a way to capture what is being executed in Office using Visual Studio or something else?

Thank you for your help,

Jer
0
Comment
Question by:WvrLthr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
9 Comments
 
LVL 35

Assisted Solution

by:[ fanpages ]
[ fanpages ] earned 225 total points
ID: 39170447
Hi Jer,

I am not familiar with the product you are using, but it does seem like there is a version of the Add-in for Excel, & possibly a different one for Word:

Excel ("Download OracleBI Spreadsheet Add-In 10g"):
[ http://www.oracle.com/technetwork/middleware/bi-foundation/index-090376.html ]

Discussions about Excel & PowerPoint (only):
[ http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/bi_addin/bi_office.htm ]

Discussions of a "Template Builder for Word", but an "Excel Analyser":
[ http://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40084/T434820T487781.htm ]

(Note: Office 2010 is not mentioned here)

"Download BI Publisher Add in For Word"
[ http://oracleappstec.blogspot.co.uk/2012/03/download-bi-publisher-add-in-for-word.html ]

These separate pages lead me to believe that there is a separate Add-in for Excel & another for Word (or else both products would be mentioned on any of these pages).

Are you sure you are using the most up-to-date Add-in (for your version of Microsoft Office)?

BFN,

fp.
0
 
LVL 14

Assisted Solution

by:Stacy Brown
Stacy Brown earned 225 total points
ID: 39172735
Here are a couple of ideas, though you may have already tried then.

Have you checked the Disabled items in Word?  
File > Options > Addins
At the bottom, change the Manage dropdown to Disabled Items and Click GO.
If anything appears in the box, select it and enable it.

You could also take a look at the Com Addins and make sure that your Addin is actually checked so that it is working.

Are there any startup templates involved with this Addin?  Word's default startup location is usually C:\Program Files\Microsoft office\Office14\Startup.  You may also find startup files under %appdata%\microsoft\word\startup.  If the startup templates are appearing under the user profile, try moving them to the Program files location and see if that makes a difference.
0
 
LVL 1

Author Comment

by:WvrLthr
ID: 39172860
fanpages,

Thank you for the reply.  I looked at the links you provide and they are mostly related to an older version of BI Publisher.  I do have the latest version and this version has both Word and Excel addins in the same install.  The link I am using is http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html and the download is the Oracle BI Publisher Desktop for 11.1.1.7.0

Thank you for your time and making sure I have the correct version.  Sometimes that can be the answer.

Jer
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Author Comment

by:WvrLthr
ID: 39172865
finalword,

Thank you for your reply.  Yes, I have checked the status in the Add-ins.  I didn't look at Startup Templates.  Unfortunately, I can't do that at this point since the machine is installing some Windows Updates and I have the Publisher software currently uninstalled.

I will make a point of looking at that tomorrow and reply back.

Jer
0
 
LVL 14

Expert Comment

by:Stacy Brown
ID: 39172899
Sounds good Jer.  I'll check back tomorrow.
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39172957
Hi again Jer,

Sorry I could not be of any further help.

I hope your issue is resolved soon.

Good luck.

BFN,

fp.
0
 
LVL 1

Accepted Solution

by:
WvrLthr earned 0 total points
ID: 39175241
finalword,

There was nothing to look at in the Addins or Startup.  I tried several things and ended up going back a couple releases on the Addin and it is working, so the issue seems to be an Oracle problem.

Thank you for your suggestions,

Jer
0
 
LVL 14

Expert Comment

by:Stacy Brown
ID: 39175258
Glad you found a solution, Jer!
0
 
LVL 1

Author Closing Comment

by:WvrLthr
ID: 39186871
Thanks to both of you for suggestions.
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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

752 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