excel interface

[chip]

I have been using the excel interface to BA for some time now (many months actually) with no real problems. that is until the last few days.

[chip]

Sorry, hit the button too soon.

Anyway, in the last few days I have found it very difficult to secure a connection between BA and excel. I have experimented with the multiple sheets link, the single sheet link. I routinely kill all excel processes before trying to connect but to no avail.. today I can't get a connection

Anyone know why things have become unrelaibale?

[chip]

I may have just found something.

If when I start BA up. I select a market from the quickpick list and then try to connect to excel - failure.

But if I connect to excel without a markat selected from the quickpick list then - success.

[GaryRussell]

API problems wouldn't cause that problem. Does the same happen if you use a blank new workbook with no other workbooks open? If it doesn't then it could be something specific to your workbook.

[chip]

when i encounter problems I usually try and link to a blank workbook. Today I have been having all sorts of problems, but I am up and running now