Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 and OLAP problem
Hi
We have SQL Analysis 2000 running with four databases (db1,db2,db3,db4). Each database has a number of cubes in it. If I try to connect to any of the cubes residing in databases db2, db3 and db4 I get this message: Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server. All cubes are properly processed. And furthermore if I try the same thing with Excel 2003 everything works. If I do following with Excel 2007 it also works: On sheet1 connect to db1 any cube, then go to sheet2 and then connect to any cube in db2, db3 or db4, it works. It is a bit awkward workaround. Have anyone solved this problem. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 OLAP Pivot table Row Filters | Excel Discussion (Misc queries) | |||
OLAP tools option in Excel 2007 greyed out | Excel Discussion (Misc queries) | |||
Excel 2007 Error with OLAP KPIs | Setting up and Configuration of Excel | |||
Importing local OLAP cube in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Pivot OLAP | Excel Discussion (Misc queries) |