ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HELP URGENT PLEASE !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! (https://www.excelbanter.com/excel-programming/290329-help-urgent-please.html)

Juanjo[_2_]

HELP URGENT PLEASE !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
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




All times are GMT +1. The time now is 09:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com