Client Saftey Option in Excel 2003
 

Hi all.

I have a pivot table poplulated by a cube. when i say refresh the data I get
the error "Client Saftey Options do not allow pass through statements to be
issued to the data source"

does any one know a way around this as its very usefull to be able to
refresh the data instaed of having to recreate the pivot table everytime.

Reagards

Ritesh