Hi everyone,
I have a sheet i have set up using macros, vba and userform.
Here is a sample of the data -
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.
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
I have a sheet i have set up using macros, vba and userform.
Here is a sample of the data -
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.
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