Pivot Table doesnt format same with new data

AnvarJay

New Member
Joined
Jun 21, 2021
Messages
17
Office Version
  1. 2010
Platform
  1. Windows
Hi everyone,
I have a sheet i have set up using macros, vba and userform.
Here is a sample of the data -
1625554664230.png


The last three are just three dummy ones i added in. What is in them doesnt matter and it doesnt matter some columns have no data for this purpose. I saved the workbook, then came back in after setting up the pivot table and then entered the three new entries.

This is how the pivot table looks for the end of the report.

1625554834398.png


See how between lines 1115 and 1117 there is a gap but it isnt in the source data which is line 1112 and 1113. I did not change any settings and all blank lines set to not show. Has anyone every experienced this before or know what it may be.
I can add any other info if anyone needs it. I am using Excel 2007 and Excel 2010 which both seem to do it.
Thanks
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,144,612
Messages
5,725,315
Members
422,612
Latest member
Sanussha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top