Refresh a sheet that come from a pivot table

Question

Hello,&nbsp;I made a pivot table and understood how to refresh it. However I don't know how to refresh the details coming from the pivot table. When you double clic on a cell in the pivot table, a new sheet appears with the details of this cell, how can I refresh it too when I refresh my pivot table?&nbsp;&nbsp;Thank you for your help.&nbsp;Alice

detlef_lewin · Answer

Hello Alice&nbsp;You can't refresh an existing drill down from a pivot table.&nbsp;Workaround:Delete the old drill down, refresh pivot table and drill down again.&nbsp;

vijaykumar shetye · Answer

Dear Alice BORE,Kindly refer to the attached file. This is basically a sample file that demostrates how the entire activity can be done by using formulas, without the use of a Pivot Table.The Grey coloured cells which have been introduced in the Data sheet are Index columns. Yellow coloured cells contain formulas. Orange coloured cells have Drop down menus for selection.&nbsp;There are 2 independent output sheets. You may retain the sheet that you prefer to use.The original sheets have not been disturbed. A Data sheet is a replica of the original data.&nbsp;The entire output has been generated using the Index function. Match function has been used for both Rows and Columns. The Index Columns, filter out the required data. If you need to filter the&nbsp; data based on multiple criteria, then edit the formula in the grey index columns.&nbsp;The ISBLANK function helps to eliminate zero from blank cells. In case cells in the data sheet, which appear to be blank have some formula, the you may need to replace the ISBLANK part with If(LEN(Index Formula)=0,"", Index formula)&nbsp;Do let me know if this is similar to what you want to do. If you need some clarifications or ammendments, then let me know.&nbsp;Vijaykumar Shetye,Spreadsheet Excellence,Panaji, Goa, India

Forum Discussion

Refresh a sheet that come from a pivot table

2 Replies