ExcelNoob222
Board Regular
- Joined
- Jun 17, 2020
- Messages
- 77
- Office Version
- 365
- Platform
- Windows
Hi.
I have some pivot tables built off of a table. As an example the table goes from A1-S300.
I have an intake tab where users can paste data into and then run a macro. The macro cleans up the data and then adds it to the bottom of the table. It then uses
ThisWorkbook.RefreshAll
To refresh all of the pivot tables.
However, after refreshing the pivot table, it adds 396 rows to my table and thus causing blank rows with #n/A and blank to show in my pivot tables.
The 396 does not match the amount of data i have added to the table and it is happening when the "ThisWorkbook.RefreshAll" is ran. If I remove this line of code and only update the table, the table has the correct amount of rows. If I manually refresh the pivot tables it also adds these blank rows.
Any ideas?
I have some pivot tables built off of a table. As an example the table goes from A1-S300.
I have an intake tab where users can paste data into and then run a macro. The macro cleans up the data and then adds it to the bottom of the table. It then uses
ThisWorkbook.RefreshAll
To refresh all of the pivot tables.
However, after refreshing the pivot table, it adds 396 rows to my table and thus causing blank rows with #n/A and blank to show in my pivot tables.
The 396 does not match the amount of data i have added to the table and it is happening when the "ThisWorkbook.RefreshAll" is ran. If I remove this line of code and only update the table, the table has the correct amount of rows. If I manually refresh the pivot tables it also adds these blank rows.
Any ideas?