Consulting

Results 1 to 5 of 5

Thread: Using Structured Cell References

  1. #1
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location

    Using Structured Cell References

    Why would the structured reference at the end of the following formula, {=AVERAGE(IF(((DATES>=TODAY()-$G6)*(HOUR(DATES)<12))>0,(tblBP[SYS])))}, automatically get changed to {=AVERAGE(IF(((DATES>=TODAY()-$G6)*(HOUR(DATES)<12))>0,(BP!$B$3:$B$880)))} once the workbook is saved and I exit Excel? Every time I go back into Excel and open the workbook the formula has been changed to reflect fixed cell references rather than the original structured table reference.

    I have the "Use table names in formulas" option checked. I am using Excel 2007.

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    I am just guessing, but square brackets are a shorthand for 'Evaluate.'
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location
    Quote Originally Posted by SamT View Post
    I am just guessing, but square brackets are a shorthand for 'Evaluate.'
    I haven't a clue. All of the tutorials I have reviewed regarding structured formulas for references to tables reflect the square brackets as the correct way to reference a particular column within a table.

  4. #4
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Let's see the workbook where this is happening!
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  5. #5
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location
    I was hoping there would be some glaringly simple superficial thing I was overlooking. I can easily get around the issue by naming the ranges within the table and just referencing the named ranges instead. Thanks.

Posting Permissions

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