Pivot Table Changes with other users

Question

I have a master Excel file that is used daily for entering and summarizing data. The main data is entered on one worksheet and a pivot table is refreshed, referencing the new data on another worksheet. When I open the worksheet, overwrite the existing data with new data, then refresh the pivot table, all fields are presented correctly, whether there is data or not. When my peer opens the same file from a shared folder, overwrites the data and refreshes the pivot table, only fields with data are presented. The "Show items with no data" is selected in her options, but not all options show in the new pivot table. We have both put the same data into the workbook and get different results in our pivot tables. Why isn't the master file performing the same for her as it does for me? Is there a setting in her Excel program that I've overlooked?

Answer 1

Hi RP,

Sorry to bother you.

Just want to see if you will need any further assistance through this post. Thanks again and wish you a good day!

Best Regards

Norman

Answer 2

Hi RP,

I probably don't know much about pivot tables in Excel, it's probably beyond my knowledge. If you need some specific analysis on some issues, It is recommended that you go to our Pro TechForum to post and discuss: IT Pro docs.microsoft.com , and they will give you further help.

Sorry I may not be able to directly help you with this, but I think I can at least direct you to the right place.

Thanks for your patience and wish you everything as well ^.^

Norman