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
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies