Forum Discussion
auto update pivot table
jitterbug888 Just press "Refresh" after you have entered new data, then your number for January 2018 will be included in the PT.
Follow up question to this issue. I've used Excel for years and have created pivot tables on numerous occasions. I'm running into some issues since I moved to Office 365 on my Mac. I'm using an iMac with the latest updates to Excel 365.
I have a pivot table that is not automatically adding one particular row that is something different from what's in the pivot table rows when I refresh the pivot table. (It used to work that way.)
The area of the data source has not changed - it's set up so that I have a major break for "project" and underneath that rows for "type". I added a new "type" today, and, thinking that since it is within the original data source, it would automatically populate when I refreshed the pivot table.
What step(s) am I missing? is there a section specifically for Mac Excel users?
Thanks,
best to attach your chart, or a copy of it without sensitive identity information. dkinpgh1
if its a table check the tables not broken, or as Riny showed me create a new sheet and start again have no gaps in your data table and generate the pivot table from it. Make a copy of your doc and give it a try.