I am using a pivot table wizard that summarizes labor hours for each employee based on work order. My pivot table wizard gets its data from several worksheets that have monthly reports. Is it possible to change the source data for my pivot table wizard to include a new spreadsheet that has new records?? Any help is much appreciated...
Bookmarks