Skip to Content
author's profile photo
Former Member

Cell referencing stops working -Bex

I have an issue with Bex -

Users all the time reference a cell for some other

calculation in the workbook. When adding a new free

characteristics, the cell referencing stops working

since the data is pushed down by the new row. Is

there any way to change queries in a workbook

without affecting Cell references? </b>

Please advise on this.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 04, 2005 at 03:32 AM

    You could have the reference cell in the 2nd sheet in the same workbook..and then use the VLOOKUP functionality

    We are using a similar approach for some complex calculation..

    Hope this helps

    Ashish

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 04, 2005 at 06:05 AM

    Hallo

    in the bex you have the option to move result area (Bex tool bar) to another sheet.

    your issue is common when you add addtional Charact. as the rows shift down if the result area is on the same sheet.

    Mike

    Add comment
    10|10000 characters needed characters exceeded