Forum Discussion

Tracey_2020's avatar
Tracey_2020
Copper Contributor
Jun 25, 2020

Pivot Table

Is there a way to make an Excel spreadsheet and load the pivot tables you want to use to each tab and then copy/past the raw data on another tab to have it auto populate into the tables?   Just won...
BI & Data Analysis
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Jun 25, 2020
Yes that is exactly what you should be doing: Have a separate worksheet, perhaps called Data, on which you keep your data. How that data gets on that sheet depends on where the data currently is. You state paste, where did you copy?
  • Tracey_2020's avatar
    Tracey_2020
    Copper Contributor
    Jun 25, 2020

    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 

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jun 25, 2020

      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.

Resources