Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Data freeze in excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-04-2009
Member
 
Join Date: Feb 2009
Posts: 14
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.

Reply With Quote
  #2  
Old 23-04-2009
Member
 
Join Date: Jul 2008
Posts: 20
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.
Reply With Quote
  #3  
Old 23-04-2009
Member
 
Join Date: Dec 2008
Posts: 65
Re: Data freeze in excel

With the $ I think, something in this genre ... E18>> $ E $ 18, it freezes you for your cell calculations.
Reply With Quote
  #4  
Old 23-04-2009
Member
 
Join Date: Nov 2008
Posts: 70
Re: Data freeze in excel

Options> Forms> Calculation

Check "Manual".

Then F9 to trigger the re-calculation.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 09:47 AM
How to normalize Excel data in Excel Rows Hache hi MS Office Support 2 24-02-2012 06: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 10:59 AM
How to check data validation compatibility of excel 2010 on excel 2007 Zoello Windows Software 6 17-05-2011 10:00 PM
How to keep freeze pane in HTML from Excel? Dilbert Software Development 4 25-01-2010 09:52 PM


All times are GMT +5.5. The time now is 03:40 PM.