+ Reply to Thread
Results 1 to 2 of 2

Accidentally renamed a cell in Pivot Table , unable to revert the change

  1. #1
    Registered User
    Join Date
    12-13-2022
    Location
    Hong Kong
    MS-Off Ver
    Microsoft 365
    Posts
    1

    Question Accidentally renamed a cell in Pivot Table , unable to revert the change

    As shown in below picture, "25/11/2022" has a different alignment with other dates in the same column of the Pivot Table.

    Pivot Table Error.PNG

    I've accidentally renamed "25/11/2022" in my Pivot Table into a random text value. It took me a while until I realized the mistake but by the time it was already too late since I've made some changes in other sheets and have already saved the file.

    I've manually changed it back into "25/11/2022" but it continues to come on top of "01/11/2022" and has a different alignment with other dates. I've tried everything I could, including the following methods I found online but none of them helps:
    -Excel Options > Data> Disable automatic grouping of Date/Time columns in PivotTables
    -PivotTable Options > Data > Retain items deleted from data source > None
    -Removing the "Date" column once and adding it back again

    It seems like Excel has identified "25/11/2022" as a special date group and remembers the change forever. I've searched online about how to clear cache in Pivot Tables but none of the websites provide the solution I need. It seems like the only method is to delete the entire Pivot Table and re-create it from scratch.

    If anyone here knows how to clear cache of a Pivot Table and ensure that it displays data exactly as the data source without having to re-make the Pivot Table, I would be grateful if you can share with me your knowledge. Thank you.
    Last edited by racaywt; 12-13-2022 at 12:27 AM.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Accidentally renamed a cell in Pivot Table , unable to revert the change

    Kindly see the yellow banner on top of page. Attach sample file


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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: 0
    Last Post: 08-04-2017, 09:51 PM
  2. [SOLVED] Worksheet Change? Use a formula cell as input and then revert back to original formula...
    By trickyricky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2016, 11:39 PM
  3. [SOLVED] Pivot table - Unable to navigate to source data from pivot table
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2016, 10:37 AM
  4. Write Cell Value to Pivot Table - Unable to get the PivotFields property error
    By vmaynard25 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-23-2016, 03:13 PM
  5. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  6. Unable to link pivot table item in field list to value in a cell
    By VBAprogrammer3502 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2013, 11:13 AM
  7. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM

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