It appears that BusinessQuery (5.1.2) and Adobe Acrobat 5 (the full version, not the Reader) cannot coexist on the same PC. Both of these products install an Add-in into Excel. And, they both create a new menu inside of Excel. We can get either one of these to install. But, we can’t seem to get both of them installed and working on the same machine. Version 4 of Acrobat works fine with BusinessQuery, but it does not have an Add-in for Excel. Has anyone else experienced this problem and found a solution? So, far the only solution we have is to remove Acrobat 5.
Is there a simple way to de/un-install just the Acrobat plugin for Excel so I can test this theory?
Chris Pohl,
Mellon Bank
NT 4.0 sp6a
Business Query 5.0.4
Excel 97-SR2
Adobe Acrobat 5.0.0 3/15/2001
From me:
Yes, everything works fine but try to explain to my users that the GPF is no big deal.
We are (partially). . .
Windows 2000 Pro Service Pack 2
BusinessQuery 5.1.2
Excel 2000 SR-1 (MS Office 2000 SR-1) Enterprise Adobe Acrobat 5.0
Curiously enough, the GPF doesn’t occur with Windows XP.
I think to really test it, you have to completely uninstall Adobe Acrobat.
I did report this to BusObj; they sent me an old fix for NT sp4 (I told them we were Win2000 but I suppose they thought it was worth a try). The fix didn’t work; they haven’t gotten back to me yet.
In a message dated Wed, 26 Sep 2001 4:26:17 PM Eastern Daylight Time, Pohl Christopher J pohl.cj@MELLON.COM writes:
Is there a simple way to de/un-install just the Acrobat plugin for Excel so I can test this theory?
Chris:
I think that there is an “add-in” menu similar to BusObj. (Tools + Add Ins from the menu bar.) Simply remove the reference to Adobe. The other thing to check is make sure that Adobe did not put an XLS file in the “auto open” directory. That can be found under Tools + Options. Look for something in the “alternate startup file location” path.
In a message dated Wed, 26 Sep 2001 4:34:36 PM Eastern Daylight Time, “George, Karen” Karen.George@SSCIMS.COM writes:
HI: We need both of them added in! How do I work around this?
You don’t have to use the add-in to Excel to be able to use Adobe to capture output. Just print to the adobe print device (unless it has changed recently). I am using an older version of Adobe, and I don’t miss a thing without the add-in. Except for problems with BusinessQuery.
Tell your users it’s a “feature” … allows for a quicker exit from Excel
I found out how to turn the Acrobat plugin off/on easily … (for Office/97, probably something similar for 2K) … Acrobat puts a file called “PDFMaker.xla” in “C:\Program Files\Msoffice.32\Office\XLStart” … Simply remove the file and Acrobat doesn’t load on startup, no GPF on exit either … Sorry Dave, there’s no checkbox for Adobe in Excel’s Tool’s/AddIn list (If anybody from Adobe is listening: “that would’ve made more sense”)
It still doesn’t answer your question of how to get them to play nice together. The fix is probably going to involve a new release somewhere (Excel, Windows, Adobe or BQ) … Did you check the Adobe site for a patch/release? How 'bout just making XP a requirement for running both together?
Yes, everything works fine but try to explain to my users that the GPF is no
big deal.
Curiously enough, the GPF doesn’t occur with Windows XP.
I think to really test it, you have to completely uninstall Adobe Acrobat.
***************************************************************** DISCLAIMER: The information contained in this e-mail may be confidential and is intended solely for the use of the named addressee. Access, copying or re-use of the e-mail or any information contained therein by any other person is not authorized. If you are not the intended recipient please notify us immediately by returning the e-mail to the originator.
In a message dated Wed, 26 Sep 2001 4:58:17 PM Eastern Daylight Time, Pohl Christopher J pohl.cj@MELLON.COM writes:
I found out how to turn the Acrobat plugin off/on easily … (for Office/97, probably something similar for 2K) … Acrobat puts a file called “PDFMaker.xla” in “C:\Program Files\Msoffice.32\Office\XLStart” … Simply remove the file and Acrobat doesn’t load on startup, no GPF on exit either … Sorry Dave, there’s no checkbox for Adobe in Excel’s Tool’s/AddIn list (If anybody from Adobe is listening: “that would’ve made more sense”)
That’s what I was talking about when I suggested checking the “automatic start” location. You can reset that location within Excel; any file found in that directory is automatically loaded when you start the program.
This worked for us. I agree we shouldn’t have to do this, and my users are not happy about having to change their Acrobat habits. I do agree that Acrobat and Excel should play nice together and I will also pursue that. KSG
