Re: Pivot Table Refresh
the pivot table gets its data from a range that is not in the pivot table work book but work book C.
Its basically a time sheet. Work book C has a lit of jobs worked on on different days and the time worked on the jobs.
The pivot table then collates this data to add up the times for each job.
Work sheet B then takes the data from the pivot table and works out a fee for each job.
Work sheet B looks at numerous pivot tables from numerous employees to get the total time worked on that job so it can be very time consuming to open up each pivot table and refresh it so that work sheet B can et the current times!