Reset labels which have been overwritten

**Holgarsson** · 09-13-2017, 07:58 AM

Hi All

Can anyone tell me how to reset labels in pivot tabels which have been overwritten?

Regards
Kari

**xlnitwit** · 09-13-2017, 08:10 AM

Hi,

Do you mean field names, or the items within a field?

**Holgarsson** · 09-13-2017, 09:36 AM

Hi

It is Items within a field.

I have some tables with overwrites that i want to reset to the source data.

Is there a way to indicate which cells have been overwritten?

Thanks
Kari

**xlnitwit** · 09-13-2017, 10:41 AM

The simplest method is usually to remove the fields from the pivot table, refresh and then put them back. If you want to highlight them, then I think code would be needed.

**Holgarsson** · 09-14-2017, 01:03 AM

Thanks for your answer.

Out of curiosity, how can you reset field names?

**xlnitwit** · 09-14-2017, 05:27 AM

Field captions should reset if you drag them off the pivot table and back on.

**Holgarsson** · 09-15-2017, 12:46 AM

Thanks for the tips.
I needed to drag them off the pivot, change the headline in the source table, update and then drag it back.

Reset labels which have been overwritten

LinkBack

Thread Tools

Rate This Thread

Display

Reset labels which have been overwritten

Re: Reset labels which have been overwritten

Re: Reset labels which have been overwritten

Re: Reset labels which have been overwritten

Re: Reset labels which have been overwritten

Re: Reset labels which have been overwritten

Re: Reset labels which have been overwritten

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] I need to create a reset button that will reset rows containing a specific value

Not sure why the rows are overwritten???

VBA Code Help - If file overwritten, continue. If file not overwritten, show warning.

how to do that the date would not be overwritten

Excel 2007 : Preserving Overwritten Data

overwritten file

[SOLVED] Can you recover a file that was overwritten

Bookmarks

Bookmarks

Posting Permissions