Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Isabela_9my pe Simpatie.ro
 | Femeie
24 ani
Constanta
cauta Barbat
32 - 48 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 961
|
|
I have a pivot table connected with a slicer. I made an excel file and used the data, then copied the file and replace the entire raw data of the pivot with new data.
The old data still exists in the slicer because of the pivot table - it's in the pivot table's cache.
Just refreshing the pivot table didn't help.
To remove the old entries, do the following:
- Right click your PivotTable> PivotTable Options
- On the Data Tab , Change "Number of items to retain per field" from Automatic to None and press OK.
- Then refresh your PivotTable.
The Filters on the PivotTable and the Slicer will now only show values that are currently in the dataset.
Source (Steven Martin's answer):
https://stackoverflow.com/questions/381 ... rom-slicer
|
|
| |
|
