The businessquery menu doesn't appear in Excel

other Business Query
1

When connecting to the BQ add-in with Excel 2002 the Businessquery menu is nowhere to be seen. The toolbar is available but with limited options.

I tried a clean install of BO 5.1.6. but it didn’t help.

Any suggestions what might be wrong?
Thanks

x00sabee (BOB member since 2003-04-23)

2

wondering if you did all the parts?
install from CD first of course
in Excel - tools … add-ins …browse to BO folder and then add BQAPI.XLL
then BQ should show up on menu bar

scott copeland (BOB member since 2002-08-15)

3

That’s exactly what I did but the last line didn’t work out : no extra menu-item for bq in sight

x00sabee (BOB member since 2003-04-23)

4

What do you mean limited options. You should have very few options availalbe until you use the LOAD option.

Steve Krandel :us: (BOB member since 2002-06-25)

5

Well, the LOAD function isn’t available either.

Although the add-in is loaded in Excel, the businessquery menu-item doesn’t appear in the Excel menu’s.

x00sabee (BOB member since 2003-04-23)

6

just wondering if you made any headway on this. Is it possible that you have something set in Excel options to show only a partial menu and tool bar? I’ve done several installs of BQ and different versions of Windows and never had any problems. Also, are you logged in as local admin or power user (or whatever Windows calls it now) so that you have rights to modify?

scott copeland (BOB member since 2002-08-15)

7

No headway yet.
I’m logged in as a local administrator and I can’t seem to find any options restricting external add-ins to be seen. It’s also the first time I encounter this problem, before all installations went OK

x00sabee (BOB member since 2003-04-23)

8

Do you have BusinessObjects installed as well as BQ? Is BusinessObjects in the path (environment setting)?

Dave

Dave Rathbun :us: (BOB member since 2002-06-06)

9

Everything’s installed - believe it or not but two days after the incident everything worked fine again without me having tried anything new. :shock:

Must have been one of these software-mysteries again… I guess this closes the case, thx for the tips!

x00sabee (BOB member since 2003-04-23)

10

Hmmm – I wonder if the installation required a reboot? If so, that would explain why now (probably after a reboot) it appears to be working properly.

Anita Craig :us: (BOB member since 2002-06-17)

11

BusinessQuery - at least the last time I worked with it - had to have the BusinessObjects application folder in the path. Since it involved a change to the environment, it required a reboot. That’s why I asked the question I asked earlier. 8)

Dave

Dave Rathbun :us: (BOB member since 2002-06-06)

12

Hi all,

Menu is not appearing between data and window in EXCEL when i select the BIQRY.dll. i’m using windows 2000 professional. i’m setting path in system variable like path = C:\program files\Business objects; %path%;

thanks in advance

RadN :us: (BOB member since 2003-04-28)

13

I’m not sure what the BIQRY.DLL is. Did you try these instructions?

KSG :us: (BOB member since 2002-07-17)

14

Hello,
I have the same problem on Windows 2003, Excel 2003 and BO6.5.1.
I load BQAPI.xLL in Excel with the addin menu and then no menu appear on the menu bar ?

gomendy (BOB member since 2005-04-13)

15

I have been doing some intensive testing with a business query migration from version 5.1.6 to 6.5.1 and although Bus Obj says there is no migration procedures other than opening in the new version, they seemed to have not done their homework with *.bqy files that are migrated to a new 6.5.1 repository that was not upgraded from a prior version. I have written a migration tool for the *.bqy files that I will post on BoB later, but for purposes of this thread I though I would give you some insight to my testing.

The problem you are experiencing with BusQuery menu not appearing can be related to the fact the BQ was not installed during the original installation of Business Objects. In most cases of installing BQ before BO was install or if BQ was installed as a ‘modify’ of the installation later, there were problems in Excel.

In most cases, this support site http://www.techsupport.businessobjects.com/search/Beta/Viewtechresdb.asp?Cmd=View&Level=0&Item=0&ID=7007 for Resolution 7007 was very helpful when trying to uninstall and reinstall BQ. It also points to a resolution #6117 which was helpful as well.

My original task was to try and load BQ with Zabo only and not FC. I came close (obtained a login screen during load), but failed to get any further with version 6.5.1.

Anyway, on one machine, I had to go as far as uninstalling BQ with the Resolutions previously mentioned, uninstalling BO, reinstalling everything and then I had to send a packed workbook to the machine and unpack it before I could get it to work properly. The long and the short of it… if you plan to use BQ you better load it at the time of the original installation.

If you have specific questions regarding my testing, please let me know and I will try to answer.

Hope this helps.
Have a great evening.

MayhewM :us: (BOB member since 2003-10-22)