none
Excel Pivot Table does not display all items - Please Help! RRS feed

  • Question

  • Good day everyone.

    Hope all is well.

    I created a Pivot Table in Excel with thousands of names, but could not access all names when filtering, and received the following message: "This filed has more than 10,000 items. Only the first 10,000 items are displayed."

    Is there a work around that issue?

    There is no way for me to clean the data with the intent to reduce the amount of items, because the items are customer names, and I need all the names, and filtering multiple items in addition to filtering by names.

    It is a spreadsheet with close to 800 thousand rows and about 25 columns, but I need filtering about 8 or 9 different items, however only the names (column) contain more than 10K items.

    If there is no way around that issue, does anyone have suggestions?

    In advance, I want to thank everyone for your time reading my post and your help.

    Sincerely 

    Ibuprofen & Ice

    Wednesday, August 14, 2019 4:18 PM

All replies