Freeze data in an external data range
Freezing an external data range retains the data but not its underlying query, so a frozen external data range cannot be refreshed.
- Click a cell in the external data range that you want to freeze, and then click Data Range Properties on the External Data toolbar.
- Under Query definition, clear the Save query definition check box.
Note When you save your workbook, the underlying query is deleted from the workbook. However, the saved database query files (*.dqy or *.odc files) are not deleted. If you saved the query when you created it in the Query Wizard or in Microsoft Query, the query file is saved on your computer and you can use it again to retrieve external data. For more information, see Microsoft Query Help.