Cell references auto update when sorting

[Chris]

I am working on a document in Excel that contains several tabs. I
have some cells reading from cells on other tabs. For instance, on
tab 1 in cell A3 let's say I have "Corie". Then on tab 2 in G3 I have
"=tab1!A3". I hope this is making sense so far.

Anyways, let's say that I add in a new row, bumping cell A3 to cell
A4. Cell G3 in tab 2 automatically knows to update itself. However,
when I use the sort feature, this automatic update does not take
place. In other words, if I sort the information and Cell A3 that
says "Corie" is moved to A9, cell G3 will continue to read from A3.
Is there a way I can tell it to automatically update itself when I
sort? Thanks for your help, Corie

 

[Guest]

Hmmm... I also have cells that reference other sheets (you call them tabs) so
I tried inserting some rows and my reference changed from D38 to D40. It
knew I added 2 rows and made the appropriate change. Continued to reference
the correct information. The exact wording of that cell is ='Mar 07'!D38

Mar 07 is the sheet it is referencing. Don't know if it makes a difference
but does your sheet name have the ' around it? You don't show them in your
example below. Otherwise, I dunno what the error is as it works on mine.

Good luck.

 

[Guest]

I just reread your post and realized I misread it. You weren't inserting
rows, you were sorting. duh. I've also ran into this problem in another
spreadsheet I use. I've found that if I sort the original sheet (the first
sheet that the 2nd sheet references), the 2nd sheet will reflect this new
order. Not sure if that will suit your need but it fixed mine. Good luck.

 

[Chris]

Ah, thanks for the help!

You are completely correct. The references do automatically update
when adding or deleting lines, it seems that they don't automatically
update when I sort. It seems that 'sort' is the only feature where
references don't automatically update, which makes me wonder if it is
a setting somewhere in my excel program.

Does anyone know how to make the references update after a sort?

--Corie