1/15/2024 0 Comments Excel 2016 pivot table cheat sheetUsually 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |