K
Keren
Hi,
I want to import a local OLAP cube file as the data source for a pivot table.
In Excel 2003 all I needed to do is to choose "import external data" and
browse for the cube file.
In Excel 2007 I couldn't find a straightforward way. I had to choose "From
Access" option in the "Get External Data" section of the "Data" tab and than
in the browse window change the file type to "All files" and than browse for
the local cube.
What have I missed? Is there a straightforward way to do this?
Thanks,
Keren
I want to import a local OLAP cube file as the data source for a pivot table.
In Excel 2003 all I needed to do is to choose "import external data" and
browse for the cube file.
In Excel 2007 I couldn't find a straightforward way. I had to choose "From
Access" option in the "Get External Data" section of the "Data" tab and than
in the browse window change the file type to "All files" and than browse for
the local cube.
What have I missed? Is there a straightforward way to do this?
Thanks,
Keren