J
Juanjo
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
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