Refreshing data in a pivot table

[Guest]

At work we have just upgraded to Office 2003 and I have a pivot table over a
cube where the data source is an AS400 file. When I try to refresh the data I
get the following message 'Client safety options do not allow pass through
statements to be issued to the data source' What does this mean??

 

[Guest]

Hello Tanya,

I found an MS Support article that seems to have worked for me.
http://support.microsoft.com/default.aspx?scid=kb;en-us;313239.

What the article does not tell you are you will nee to highlight each
section Internet, Local intranet, and trusted sites. Then click custom and
scroll down about half way. Here you will find the miscellaneous section.
Select enable. Please let me know if this helps you
Terry