Data freeze in excel
when we generate a set of random numbers in Excel, these are calculated for you press enter or that adds up. Do you know how to fix definitely the random data? Knowing that I am using excel 2007.
Re: Data freeze in excel
Freezing an external data range retains the data but not its underlying query so a frozen 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 Button image on the External Data toolbar.
2. Under Query definition, clear the Save query definition check box.
|Tags: excel, freeze|
|Thread Tools||Search this Thread|
|Similar Threads for: "Data freeze in excel"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|How to convert monthly data into quarterly data in Microsoft Excel||Glasney||MS Office Support||4||04-01-2014 10:47 AM|
|How to normalize Excel data in Excel Rows||Hache hi||MS Office Support||2||24-02-2012 07:20 PM|
|How to insert the corresponding data into multiple worksheets from a range of data in Excel||ZaidaB||Windows Software||2||22-01-2012 11:59 AM|
|How to check data validation compatibility of excel 2010 on excel 2007||Zoello||Windows Software||6||17-05-2011 11:00 PM|
|How to keep freeze pane in HTML from Excel?||Dilbert||Software Development||4||25-01-2010 10:52 PM|