> at least you can make named tables in excel on windows I built a spreadsheet that loaded external data sources (filtered log files from a production system)

> at least you can make named tables in excel on windows I built a spreadsheet that loaded external data sources (filtered log files from a production system) into Excel tables. I then combined two log files into another table, and created a pivot table from this, which I then filtered (date ranges etc) and analysed. That worked great at the start - until I came to update the external data and found the pivot table didn't update. Then when I force an update it lost my groupings, filtering etc. Any idea where I went wrong?