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?
--
Kind Regards

Peter Bebbington