Home

PIVOT TABLE PROBLEM

Highlighted
jkraemer
Occasional Visitor

I have large spreadsheet of 67000 rows and 50 columns.  I created a table for the source data. each month I add data to the table by cut and paste from another spreadsheet.  This month the data I added  for 2019 does not show up in any of my pivot tables. I have refreshed the data, refresh all, refreshed the data table. I insert simple pivot table and put year in the rows column and it only goes to 2018. Does not show 2019.  The data is there, I even tried to change data form the table to the rows and columns and it still does not show. Have I reached some type of size threshold maybe? Any help would really be appreciated as this is a critical report for me.

 

Thanks

 

1 Reply
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies