Show All

Hide All

Freezing an external data range (external data range: A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.) retains the data but not its underlying query (query: In Query or Access, a means of finding the records that answer a particular question you ask about the data stored in a database.), so a frozen external data range cannot be refreshed.

1. Click a cell in the external data range that you want to freeze, and then click Data Range Properties on the External Data toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.).
2. 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.