Hi everyone,
I set up an Excel 2013 spreadsheet consisting of a data table and a pivot table generated from the data table. I would like to have data manually updated from an external .csv file on a daily base. When I click Refresh or Refresh all data on the standard table is updated with new lines added at the bottom. However, the pivot table never gets updated but remains populated with data up to the time when it was generated only.
Clicking Connections shows that the range of the data table is properly extended on any refresh. New lines are listed under Locations. Why doesn't the pivot table update?
Spreadsheet and reference sheet are stored in the same location. I don't get an error message.
Thanks for your suggestions in advance.
Kind regards,
Nick
Bookmarks