Hi,
Office 2013 was recently installed on our network. I'm getting used to it but seem to be having some issues with pivot tables. It seems Microsoft's moto is still the same, if it isn't broken, break it.
I am creating a simple pivot table from an access database source. I am able to connect and create the pivot no problem. However, the pivot will not refresh and pull in any new data appended to the table after the initial build. When I click on the refresh button is seems as if the pivot isn't even trying to recalculate.
If I delete the pivot and recreate it the new data will appear. All the pivot filters are set to "select all".
I am also noticing the pivot doesn't condense to remove fields with no values. This is annoying and I can't imagine the new standard for pivot, but I wouldn't be surprised if this is Microsoft's new standard.
Any suggestions on updating and condensing issue?
See attached image.
Office 2013 was recently installed on our network. I'm getting used to it but seem to be having some issues with pivot tables. It seems Microsoft's moto is still the same, if it isn't broken, break it.
I am creating a simple pivot table from an access database source. I am able to connect and create the pivot no problem. However, the pivot will not refresh and pull in any new data appended to the table after the initial build. When I click on the refresh button is seems as if the pivot isn't even trying to recalculate.
If I delete the pivot and recreate it the new data will appear. All the pivot filters are set to "select all".
I am also noticing the pivot doesn't condense to remove fields with no values. This is annoying and I can't imagine the new standard for pivot, but I wouldn't be surprised if this is Microsoft's new standard.
Any suggestions on updating and condensing issue?
See attached image.
