| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Data and Formulas
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
External Data and Formulas
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 -- Gary''s Student - gsnu200792 "Alberto" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify external references (in formulas) and color format | Excel Worksheet Functions | |||
| Drop Formulas when refreshing data from external source | Excel Discussion (Misc queries) | |||
| Array formulas won't recognize external data from Microsoft Query | Excel Discussion (Misc queries) | |||
| Fill down formulas in cells to the LEFT of external data range? | Excel Worksheet Functions | |||
| Import External Data -- Fill down formulas Issue | Excel Worksheet Functions | |||
Hybrid Mode
