Hello, in the attached worksheet I have a simple data set and pivot table that I update monthly with new invoices. I've used this worksheet for almost two years, but this month the table corrupts when I attempt to include the new March data. Typically, I copy the data from the March Data tab into the Invoice Data tab, then switch to the pivot table sheet and update the data source. For some reason, the table and chart are corrupting, for lack of better term, when I update the data source to include the new data.
I've checked that the cell formatting matches and everything I can imagine, without success. I paired this down drastically for purposes of uploading, it's typically around 100 lines per month. The data in this example through line 16 was existing data before I updated with March. Lines 17 & 18 are new data copied from the March Data tab and if you update the pivot table data source to include those lines it completely alters the table and chart. The only variable from normal was the source of the updated data so, again, I checked the cell types and don't see a difference. However, for posterity, the March data I pulled from Quickbooks Online rather than previously pulling from QB Desktop. I know that shouldn't matter, but I'm pointing it out because if I go into this worksheet and copy line 16 down to 17 instead of pasting from the March Data tab, then update the data source, it works just fine. So, it seems to be something to do with the data I'm pasting.
I'm sure it's something obvious, but I'm completely vexed and appreciate any help!!
Thank you in advance!
Bookmarks