analyze weekly detail reports using excel pivot tables

0
votes

We generate detail reports weekly of timesheet data posted to a cloud-based service request management application. We export the data as CSV files. The number of records changes each week, although the columns are the same on each weekly report.

I want to use a "standard" pivot table to analyze each week's timesheet data each week after the weekly timesheet report has bee exported. Is it possible to import the weekly data into a standard pivot table in an Excel spreadsheet where the size of the imported timesheet CSV file will change each week?

2
excelpivot-table
Can there be gaps in the rows or columns? – QHarr

2 Answers

1
votes

I have just checked and if you select the relevant /columns/ (rather than just the current cell range) before hitting Insert Pivot Table you can configure it to read the whole of $A:$D (or whatever) rather than providing a specific row bound. Hopefully that will give you what you need.

0
votes

After I figured out where I can find the function to "Change PivotTable Data Source" in Excel 365, I see that the range is already set to process all rows in the range columns (data_tab_name!$A:$I) so I was trying to fix a problem that didn't exist.