+ Reply to Thread
Results 1 to 4 of 4

Retain Pivot Table Date Format After Pivot Refresh

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    phoenix, arizona
    MS-Off Ver
    Excel 2007
    Posts
    53

    Retain Pivot Table Date Format After Pivot Refresh

    Hello - Hoping someone can solve how to retain a pivot table date format after the pivot table is refreshed.

    I would like for the pivot table dates to retain a yyyy-mm-dd format. I have attempted a few solutions but cannot seem to achieve consistency.

    On the Pivot tab, columns B, C, and S appear to retain the desired format after the pivot table is refreshed, but I am not confident this will be true after all of the data is entered.

    Column D demonstrates clear evidence of the inconsistency, as it continues to revert back to the mm/dd/yyyy format after the pivot is refreshed.

    Thank you in advance for your assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,057

    Re: Retain Pivot Table Date Format After Pivot Refresh

    With cellpointer at cell D4, move your mouse down towards bottom border until the cellpointer becomes a down arrow, left-mouse-click to select the column, then format the range as you wanted. If you did it correctly, only the range D5:D42 is selected and formatted.

    Cellpointer Arrow.jpeg
    Last edited by josephteh; 04-15-2022 at 10:50 PM. Reason: Insert image

  3. #3
    Registered User
    Join Date
    07-26-2011
    Location
    phoenix, arizona
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Retain Pivot Table Date Format After Pivot Refresh

    Hi Josephteh - Your proposed solution worked. Thank you!

  4. #4
    Registered User
    Join Date
    07-26-2011
    Location
    phoenix, arizona
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Retain Pivot Table Date Format After Pivot Refresh

    Hi Josephteh - your solution worked. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 06-23-2018, 12:14 AM
  2. Retain formatting on all Pivot Charts when table refresh
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2015, 11:38 PM
  3. Auto Format Pivot Table after refresh
    By dw_22801 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2015, 02:46 PM
  4. Retain pivot table data every time I refresh it?
    By athenavespa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2014, 07:34 PM
  5. Missing date format after refresh pivot table
    By verlax in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2014, 07:53 AM
  6. [SOLVED] Macro to update pivot item (date format) in pivot table to latest date from data source.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 03:18 AM
  7. Replies: 0
    Last Post: 06-09-2011, 04:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1