Results 1 to 3 of 3

Thread: Formulas loosing cell reference

  1. #1

    Formulas loosing cell reference



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Formulas loosing cell reference

    The spreadsheet works in Excel 2000 when you open it in any newer version it is corrupted. Which is fine so we are rewriting it in Excel 2010/2013.

    We have data in columns A:E which comes from the refreshable query. Data in F:I are different formulas based on the data from the query. The number of rows we get will vary from query to query. The headers never change just the data. How can we make it so that when no matter the data length the formulas will always autofill up or down depending on the data length?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016
    hmjjohnson... i am already trying to help you at: http://www.ozgrid.com/forum/showthread.php?t=181016

    Please try to be considerate of volunteer's time and effort..

    Please read: http://www.excelguru.ca/content.php?184

    Please post links to any other forums you posted in.


  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,512
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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