Hi,
Well, I'll try this. If I cannot manage perhaps I will ask you to help me with some code lines.
Until now I used a code that does a PivotTable update.
The code that I'm using is the following:
Sub AllWorkbookPivots()
Dim pt As PivotTable
Dim ws As Worksheet
For Each ws In...
Hi, does anyone knows to handle an OLAP cube?
I have an OLAP cube that I'd created in Excel, this is into an Excel file. This file has got many sheets and on every sheet I've put as PageItem the same field "DateTime".
Every time I am trying to select a certain date I must do the same for every...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.