External Data and Formulas

[Alberto]

Hi All,

I have developed a solution based on Access and Excell(2003).
The Excel sheet is populated with Acess data trough a External Data
Connection.
My problem is that if the number of row extracted change (plus or minus) the
formulas that refer to external data are changed by Excel (in both cases if
the references are normal or absolute), the reference are translated to some
cell up or down.
My question is how can I make my formulas unmodifiable ?

Thanks a lot
Alberto

 

[Gary''s Student]

INDIRECT() may be able to help you. FOr example

=A10+A11

will change if you add/remove rows near the top. However:

=INDIRECT("A10")+INDIRECT("A11")
will not change