Show All

Copy an external data range and its underlying query

1. Click the arrow next to the Name box on the formula bar, and select the name of the external data range that you want to copy.

   If you want to include column labels or formulas that are not part of the external data range, select the cells that contain the column labels or formulas that you want to copy. Click the arrow next to the Name box on the formula bar, and click the name of the external data range you want to copy.

2. Click Copy .
3. Switch to the workbook where you want to paste the external data range.
4. Click the upper-left cell of the paste area.

   To ensure that the external data does not replace existing data, make sure that the worksheet has no data below or to the right of the cell you click.

5. Click Paste .

Note  If you copy only part of an external data range, the underlying query is not copied and the copied data can't be refreshed.