Hi, how do I prevent columns disappearing in the pivot table if the new data does not have data that was in the column previously. I want the pivot table to keep all the columns regardless if the new data does not have all the previous data, cheers.
Prevent pivot table columns disappearing
- cobber1418
- Closed
-
-
-
There's an option in the Field settings to show items with no data. Try checking that.
There's also an option in PivotTable Options- Number of items to retain per field. Try setting the drop down to MAX
-
Thanks Roy, the first one worked, cheers.
-
Pleased to help
-
-
Maybe put some dummy data in with no value. You can force the pivot table to display zero when items have no data, enter a zero in pivot table options.
-
Unfortunately a lot of people will be using it, so not an option, cheers.
-
I don't understand why the show items with no data didn't work. My last suggestion would only be in the source data which users shouldn't need
-
They all get the data individually from a report. I'll keep checking your other suggestion, cheers.
-
If I come across anything else, I'll post back. There was a bug but I thought it had been fixed
-
Thanks Roy
-
-
Glad you sorted it it.
-
Follow these steps
- Right-click a cell inside the pivot table.
- Select “Pivot Table Options…” from the menu.
- On the Layout & Format tab, uncheck the “Autofit on column widths on update” checkbox.
- Press OK.
The columns will NOT automatically resize when changes are made to the pivot table.
-
Rickbale. That wasn't the question. Will you stop attempting to answer solved and old questions
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!