Results 1 to 4 of 4

Thread: Data freeze in excel

  1. #1
    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.

  2. #2
    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.

  3. #3
    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.

  4. #4
    Join Date
    Nov 2008
    Posts
    70

    Re: Data freeze in excel

    Options> Forms> Calculation

    Check "Manual".

    Then F9 to trigger the re-calculation.

Similar Threads

  1. Replies: 4
    Last Post: 04-01-2014, 09:47 AM
  2. How to normalize Excel data in Excel Rows
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:20 PM
  3. Replies: 2
    Last Post: 22-01-2012, 10:59 AM
  4. Replies: 6
    Last Post: 17-05-2011, 10:00 PM
  5. How to keep freeze pane in HTML from Excel?
    By Dilbert in forum Software Development
    Replies: 4
    Last Post: 25-01-2010, 09:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •