pivot table date problem

  1. Sufiyan97

    Pivot Table Slicer Shows Dates which are not actually in the data <1/1/2024 or >=1/1/2017

    I have a data in which I don't have dates <1/1/2014 or >=1/1/2017 but slicers still shows them, how to get rid of them
    • Sufiyan97
    • Thread
    • pivot table date problem pivot table slicers slicer date issue
    • Replies: 8
    • Forum: Excel Questions
  2. A

    Pivot Table - select status date from list of dates

    I have a pivot table of project data that contains (amongst other things) type of project, project costing information as well as 3 dates - project start date, project due date, project completion date. What I would like to see in my pivot table is a subtotal of costs per type of project, the...
  3. S

    Date Formats not picked up in Pivot Table

    Hello friends, I have inherited a spreadsheet that I need to update soon. It takes data that has a date field and creates a pivot table by month. The person who created it completed it thru February. Now I have added data for March and April, but the pivot tables can not find this new data...
  4. J

    Pivot table date filter disappears after updating source data

    Hi, Working in excel 2007. I have set up a pivot table to view sales figures. I download the data from an sql server and then have to run a text to columns operation so that the date is in the correct format and an can be sorted. When I built the pivot table from scratch, when I chose to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top