Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivottable and OLAP cubes
I have OLAP cubes on worksheets which draw data from an access database. I
use queries in the access database to select the data I want to see. Sometimes, some of these queries return no records, because there are none. When I open the worksheet containing the OLAP cube, it refuses to update because there is no data which means I am left with the previous data int he pivottable. Any solution ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP w/ Pivot update more than one page failure | Excel Discussion (Misc queries) | |||
Olap cube engine | Excel Discussion (Misc queries) | |||
custom functions stop working in PivotTable in Excel2003 | Excel Discussion (Misc queries) |