Pivot Tables

Resolved · High Priority · Version 2013

Mon 17 Oct 2016, 11:46 Delegate Nicky said...

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.

Mon 17 Oct 2016, 12:14 Trainer Jens said...

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

Mon 24 Oct 2016: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips