Nicky has attended:
Excel Intermediate course
Pivot Tables
Hi,
We have a pivot table which we have been using since May.
In the pivot table, there is a column entitled "blank", in the past few weeks when we have refreshed this table, the "blank" column either disappears or moves to the end of the pivot table, shifting all of our data out of place so we can not get correct figures etc.
Please can you advise why this might be, and for a suitable solution to the problem, as we can not keep editing the pivot table each with.
Thank you.
RE: Pivot Tables
Hi Nicky,
Thank you for the forum question.
I guess that you have blank cells in your source data. Excel does not like blanks. Normally Excel will put the (Blank) column as the last one in the PivotTable. If you have the information Blank in cells in you source data, the PivotTable will by default sort the columns in ascending order.
If the Blank column disappear by refresh, it will only happen if you do not have blank cells or the word blank in your source data.
If you want me to look at your PivotTable you can send me the file:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
