ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Importing local OLAP cube in Excel 2007 (https://www.excelbanter.com/excel-worksheet-functions/116641-importing-local-olap-cube-excel-2007-a.html)

keren

Importing local OLAP cube in Excel 2007
 
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



All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com