• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data filters in pivot tables running very slow

K

KiKi

Member
I have PT in excel fetching data from SQL Server. It bring millions of rows.
When i place filter it's fast but removing one filter approximate takes 1 hr. Any reason why so?> and what is the workaround for it.

any help will be appreciable.

Thank You!!
 
Toggling filter/visibility in Pivot Table is Volatile action. Given your data size, it is going to take a long time.

Better method is to design Data Query with built-in filter (SQL Statement) for desired output.
 
You must log in or register to reply here.
Back
Top