Hi, I ran into this limitation using PowerPivot, probably never noticed it before....yikes. I looked on this Board and found where someone said I should change the limit box on the data connection. see example. The problem is, all my data is in the model, so there is no data connection to adjust, AND it won't let me a
nyway. Anything else I can do?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Power Pivot 1000 line drill down limit
- Thread starter dmiller91
- Start date
Excel Facts
How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Similar threads
- Replies
- 4
- Views
- 466
- Replies
- 0
- Views
- 605
- Replies
- 1
- Views
- 1K
- Replies
- 1
- Views
- 770
- Replies
- 0
- Views
- 1K
