To retrieve external data fields, you use Microsoft Query, a tool that lets you return external data to a PivotTable.To start Microsoft Query and run the Query Wizard, click Get Data. Follow the Query Wizard steps to view and organize your data. When you click Finish in the Query Wizard, or the Return Data To Microsoft Excel button in Microsoft Query, you return to the PivotTable Wizard.
To protect a workbook so that a password is required to open it or save changes to it, click Save As on the File menu and ...
To publish the entire workbook as an interactive web page, you must have at least one worksheet in this workbook. Chart sheets, ...
To put an outline border around a range of cells, choose Cells from the Format menu, and then select Outline on the Border ...
To remove all the page breaks on a sheet, select the entire sheet and then click Reset All Page Breaks on the Insert menu. ...
To retrieve external data fields, you use Microsoft Query, a tool that lets you return external data to a PivotTable.To start ...
To review the names defined in a workbook, point to Name on the Insert menu, choose Paste, and then choose the Paste List ...
To run this query, you must specify an external data source.The query that you are running is dependent on an external data ...
To save as XML Spreadsheet, you must have at least one worksheet in this workbook. Chart sheets, Excel 4.0 Macro sheets, ...
To save time by limiting calculation to the active sheet, click Preferences on the Edit menu, then click the Calc Sheet button ...