You can change a registry setting to fix the problem. There's
information in the following MSKB article:

You receive an error when you create an OLAP cube-based PivotTable in Excel
http://support.microsoft.com/kb/887297/en-us

Souris wrote:
I got "client Safty options do not allow pass through statements to be issued
to the data source" when I refresh pivot table chart.

I am able to refresh MS query to access same MS Access tables or queries
from same database.

Are there any limited to refrsh pivot table chart using cub?

Your information is great appreciated,


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html