• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 102
  • Last Modified:

Help in powerpivot Sort

I have created a dashboard that maps records in excel sheet and sql and create a report.
I need to sort one column based on ascending. But when I click that the sort option gets disabled in the excel window.
Can some one help me with that.
1 Solution
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Make sure you are clicking on the correct cell beforehand.

Here's an example:

If I click on cell B3, the Sort & filter are disabled.

If I click on cell B4, the Sort & filter are enabled and work.

If you've tried clicking on different cells, and it still isn't working, then you need to provide more information, such as screenshots.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now