| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference to values disappear after closing file
When I use this formula in a worksheet: =INDIRECT(ADDRESS(COLUMN()+5,4,,,"C:\Temp\[januari_2010.XLS]sheet1")) The values disappear after closing the file januari_2010.xls and the error #REF! appears. Apparently this formula can't keep the reference when the file is closed But when I use this formula in a worksheet: ='C:\Temp\[januari_2010.XLS]sheet1'!$C$10 the value stay visible even after closing the file januari_2010.xls. How is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autoshapes disappear after saving file | Excel Discussion (Misc queries) | |||
| Secondary Axis Values Disappear | Charts and Charting in Excel | |||
| reference disappear | Excel Programming | |||
| All pictures disappear from my whole excel file when I use 'hidden | Excel Worksheet Functions | |||
| Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
Linear Mode
