Select the sheet that you want to make visible Video: Pivot Table Source Data
In the list, select the sheet that you want to make visible, and click OK. In the Visibility section, click Hide & Unhide, and then click the Unhide Sheet command. You can follow these steps to unhide a sheet: If the source range isn’t activated, it may be on a hidden worksheet. Usually the source range will be visible, and surrounded by a moving border. Change PivotTable Data Source dialog boxĤ. On the worksheet, behind the dialog box, you can see the source range, surrounded by a moving border. This may be a worksheet reference, such as In the Change PivotTable Data Source dialog box, you can see the the source table or range in the Table/Range box. In the Data group, click the top section of the Change Data Source command. On the Ribbon, under the PivotTable Tools tab, click the Options tab. To locate the source data for a pivot table, follow these steps: How To Locate the Source Data for a Pivot Table Instead, if you want to recreate the source data, go here – Rebuild source data The following instructions will take you to the source data, if it exists. For newer versions of Excel, go here – Find the Source Data for Your Pivot Table The following instructions are for Excel 2007. These tips will help you locate the source data for a pivot table. In some workbooks there can be several Excel tables, and it’s not immediately obvious which table was used. If someone else created that workbook, you may not be sure where to find the Excel table that was used as the pivot table’s source data. 
You might have to make changes to a workbook that contains a pivot table.
0 kommentar(er)
