Hi,

I've got a pivot table in excel 2000. The pivottable's
data source is a olap cube (exists 2
files in my hard disk .cub and .oqy).

The problem occurs when I want to filter data from cube

The cube uses a view in a SQL Server database and we need
to restrict these view depending on the value of a cell in
the sheet (for example between dates)

Is it possible to make code in the sheet that refresh the
data modifying the query?

In this sheet there are thousands of registers



MANY THANX