OLAP Cube Refresh Excel 2003

P

Peter Bebbington

I have several pivot tables linking to the same OLAP cube and after
refreshing the first table I get a message "The cube file<<filename>> cannot
be opened for writing"

Now I can get around this by closing down the s/sheet and reopening when I
can then refresh the second table.

Whilst this works it is very irritating. Can anyone suggest a better strategy?
 
Top