Hello

I have created a local cube using two ways:
1) in Excel 2003 when creating a pivot table from an olap (SQL 2005) server
2) using CREATE GLOBAL CUBE (in VB6)

The result (for both 1) and 2)) is a cub-file which can be opened in our
selfwritten browsing application (VB6 using office web controls 10 / 11
for presentation).

If I try to open this in excel using "pivot table / chart report" with
an external datasource, I can connect to the local file, but when I try
to get the data in the sheet, I always get an error (for both 1) and 2))
stating "Excel cannot find OLAP cube ABC. Either the OLAP database has
been changed or you don't have permissions to connect to the cube."

Interesting detail: although display is possible using the selfwritten
app (see above, using pivottable and chartspace controls), you get an
error when refreshing the controls (using .RefreshData-method or Refresh
in the context menu), this error states "Failed to get data ... current
session is invalid due to structural changes to the database".

Online access to the (local) OLAP server database is without any
problems (for both Excel and own app).

Any clues?

Thanks in advance
Klaus Wiesel