Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
willcob
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
OLAP w/ Pivot update more than one page failure CBK1 Excel Discussion (Misc queries) 0 April 11th 05 07:22 PM
Olap cube engine Simon Excel Discussion (Misc queries) 0 March 15th 05 08:49 AM
custom functions stop working in PivotTable in Excel2003 Mike Melnikov Excel Discussion (Misc queries) 0 February 10th 05 01:38 PM


All times are GMT +1. The time now is 01:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"