Forum Discussion
Pivot Table
- Tracey_2020Jun 25, 2020Copper Contributor
I copied the data from a report that is generated automatically and sent over each morning. I use the pivot table to organize the data into sections to review inventory data.
I generated my report using the data that is auto generated and inserted pivot tables to different tabs to organize the information / break down the data sent. I tried to copy and paste the raw data from a new report into a previous report to see if the information filtered by the pivot tables would update too but it didn't. JKPieterse
- JKPieterseJun 25, 2020Silver Contributor
Tracey_2020 That report you are talking about, is that by any chance a CSV file? You can import CSV files into your source data worksheet directly by using Data, Get Data, From File, From CSV. If the name of the file differs each time, you can also use the "From Folder" feature and then filter the list of files by their date so the most recent is on top. Then delete all rows except the first row and finally expand the data. Now once the data is in a table on a worksheet, you can point your existing pivottables at the new data. WHen all of that is done, you simply open your file and click Data, Refresh All.