Home // Blog & Excel Tips // Pivot table not pulling all data

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Pivot table not pulling all data

Comments Closed
Uncategorised

Pivot table not pulling all data

Pivot tables are great tools but due to the lack of understanding of how they work we are often told that the pivot table is not pulling all the data. There could be a number of reasons for this and some are very easy to fix.

The data source is not long enough

If the source of the data is cells within a spreadsheet, it is possible that the data is now longer than when the pivot table was originally set up. To check this click on the pivot table and click on CHANGE DATA SOURCE in the ribbon. This will take you to the source data and by looking at the highlighted area you will see if it includes all the data. You can also change it here.

The Pivot Table is not refreshed

Pivot tables need to be refreshed if data has changed. You can simply right click on the pivot table and click REFRESH.

A filter is switch on

One of the rows or columns may have some filters switched on (e.g. some of the items are unticked). If items are unticked and new data appears it will only show the data from the ticked items and any new label will by default be unticked (if there was no filter on, then new labels would by default be ticked)