To | Do this |
---|---|
Import the data to the current sheet | Click Existing sheet, and then click OK. |
Import the data to a new sheet | Click New sheet, and then click OK. Excel adds a new sheet to your workbook, and automatically pastes the external data range at the upper-left corner of the new sheet. |
Sometimes you need data that is stored outside of Excel, like in a database. In this case, you connect to the external data source first, and then you can work with the data.
To | Do this |
---|---|
Choose query definition, refresh control, and data layout options | Click Properties. |
Change the settings for a parameter query | Click Parameters. |
Return the external data to the active sheet | Click Existing sheet. On your sheet, click the cell where you want to place the upper-left corner of the external data range, and then click OK. |
Return the external data to a new sheet | Click New sheet, and then click OK. Excel adds a new sheet to your workbook, and automatically pastes the external data range at the upper-left corner of the new sheet. |
Create a PivotTable by using the external data | Click PivotTable, and then click OK. |