| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#VALUE! in OLAP based PivotTable
I have a few PivotTable reports based on MS OLAP Cubes. Sometimes, often
when I modify dimensions on the server, multiple selections within the reports would produce #VALUE! error. I have to remove some (sometimes all) of the dimensions from the report, refresh the report and bring them back to solve the issue. Does anyone know what causes this and how it can be fixed? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
| pivottable and OLAP cubes | Excel Worksheet Functions | |||
| Excel pivottable with OLAP cubes saves names, not keys | Excel Discussion (Misc queries) | |||
| How to sort a PivotTable based on OLAP Cube by one of the data fi. | Excel Programming | |||
| Load Testing Tool required for Excel Pivot table based OLAP Application | Excel Programming | |||
![Pasha[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
