I am having trouble. I have a 2016 version of excel and the other user has 365 version. When I want to update the table and I want to update the pivot table it will not allow me. It gives me an error message that states it cannot update the information. Is anyone else having this issue and if so, how do you fix it? Or is there a work around? Or do I just need to buy the newest version of Excel.