J
jimithing1980
This issue is similar to absolute/relative references, but it's relate
to the data being referenced, not the cells doing the referencing. I
I have a call the references cell A3 then I insert a row above row
(making the original A3 cell now A4), my reference automaticall
changes to A4. How can I get it to stay at A3 no matter what happens?
This may sound like an odd request, but I reference a bunch of cells o
a worksheet. This sheet retrieves data from a database which change
regularly. The changes that it receives are not just updated in th
cells, but rather the rows are deleted and reinserted changing all m
references to this sheet. For example, say I import data and it fill
cells A1 to A20 and I make a reference to A15. If I change the dat
that is imported and the data now only fills cells A1 to A10, th
reference to A15 is now set to #REF since it actually clears all cell
from A1 to A20 and then reinserts new data. Any ideas on what may b
going on and how I can fix it? Thanks in advance
to the data being referenced, not the cells doing the referencing. I
I have a call the references cell A3 then I insert a row above row
(making the original A3 cell now A4), my reference automaticall
changes to A4. How can I get it to stay at A3 no matter what happens?
This may sound like an odd request, but I reference a bunch of cells o
a worksheet. This sheet retrieves data from a database which change
regularly. The changes that it receives are not just updated in th
cells, but rather the rows are deleted and reinserted changing all m
references to this sheet. For example, say I import data and it fill
cells A1 to A20 and I make a reference to A15. If I change the dat
that is imported and the data now only fills cells A1 to A10, th
reference to A15 is now set to #REF since it actually clears all cell
from A1 to A20 and then reinserts new data. Any ideas on what may b
going on and how I can fix it? Thanks in advance