I have a pivot table in spreadsheet A.
I have some formulas in another spreadsheet B.
The formulas look up data in the pivot table in A and use that data in B to return and answer.
Is there a way to refresh the pivot table in A from B without having to open A and refresh the table?
Hope that makes sense.
Cheers
Re: Pivot Table Refresh
Hi Claire
Without opening the spreadsheet containing the pivot table, no you can't refresh the Pivot Table data. What you could perhaps do is create a macro to automate the process of opening/refreshing the pivot table workbook. From where does the Pivot Table get its data from? Is it a worksheet range in the pivot table workbook? If so, does this range get populated by links to another workbook/external data range?
Richard
Re: Pivot Table Refresh
Hi Richard,
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!
Don’t have an account yet? Register yourself now and be a part of our community!
