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