| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove data from OLAP pivot table
Hi,
I have created some pivot table reports in Excel 2007 from a SQL Server 2005 OLAP cube. Now I'd like to save the reports in a way that the data from the pivot table is not stored in the workbook but the MDX query is... If I save the workbook normally and I open the workbook in an offline situation, all the data from the pivot table is visible. I have tried to save the workbook as a template, but this doesn't work. Please help.. - Joris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert OLAP data (PIVOT Table) to formula | Excel Discussion (Misc queries) | |||
| Excel 2000 Pivot table using offline OLAP CUB as the data source | New Users to Excel | |||
| 2007 Pivot Table or OLAP Add-in | Excel Discussion (Misc queries) | |||
| OLAP Pivot Table - HT Find source data | Excel Discussion (Misc queries) | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Linear Mode
