DrilledDown function always returns FALSE

[A8_Tony]

Hi all,

First time post, let's hope i don't get the same kind of response I had elsewhere

I've created a dashboard in Excel, which has taken me some time. But it's there, and it works a treat.

However, I've recently found that when applying it to databases with a large volume of transactions it can take up to 1/2 an hour to refresh the pivot tables and charts within it!!! :O Whilst I accept that there will be a performance hit, I wouldn't have expected it to be quite so high, even though I'm using ODBC as the connection method to my SQL database.

This has led e onto moving it to a Power Pivot based solution, which I'm hoping will alleviate the problems I'm having dealing with large datasets.

The problem now is that I have a button which when clicked checks the ShowDetail property of an appropriate field, and then either sets it to True or False depending on it's current state.

The working code looks like this:

pf.ShowDetail = IIf(r.ShowDetail, False, True)

The code I'm having a problem with is this:

pf.DrilledDown = IIf(pf.DrilledDown, False, True)

The problem being that it returns false all the time!!!!

Any help would be most appreciated. (Y)

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[A8_Tony]

Apologies for the breaking of rules. Can someone help now please?

[romperstomper]

I'm not at a computer right now but I suspect that is one of the properties that doesn't work with OLAP data sources (which PowerPivot is).