| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT doesn't retain data from external worksheets
See this:
http://groups.google.com/group/micro...443753560f0075 -- Biff Microsoft Excel MVP "PeteJ" wrote in message ... I'm using the INDIRECT function to bring in data from other spreadsheets. Using this allows me to just populate a cell and automatically point to a new spreadsheet (I have dozens of spreadsheets that hold similar data, and dozens of formulas that pull that data over, so I don't want to manually edit all the formulas). However, it appears that when I use this, the file that it points to needs to be open. I have a fully qualified path ("C:\Documents and Settings\......"), so I don't understand why the document needs to be open. If I don't use INDIRECT, and manually edit the text, it does not require the spreadsheet to be open. Is this correct behavior? If so, is there a workaround? Thanks, Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data from External Worksheets | Excel Worksheet Functions | |||
| Indirect referencing of external spreadsheets | Excel Discussion (Misc queries) | |||
| Change external data source for multiple worksheets | Excel Discussion (Misc queries) | |||
| How do linked worksheets exist with data on an external device | Excel Worksheet Functions | |||
| INDIRECT EXTERNAL DATA | Excel Worksheet Functions | |||
Hybrid Mode
