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 cub

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 register


MANY THAN