| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a workaround with #REF error message?
I have a spreadsheet that uses extensively OFFSET(INDIRECT(cell),0,0,1,1))
where cell refers to a cell containing a XLS name because the filename and path change monthly. When I open the main file all my cells containing the above formula show "#REF" until the spreadsheets it's referring to are open. I have a macro that automatically opens all the referring spreadsheets ~12 files. Shouldn't Excel take a snapshot of the data once I save the main file? I want to be able to view the data as it is without opening the 12 files it's referring to. Is it possible? Any other approach is welcome. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a workaround with #REF error message?
You must open the workbook with Excel in Manual calc mode. So before
opening this workbook, check Tools, Options, Calculation. -- Jim "matelot" wrote in message ... I have a spreadsheet that uses extensively OFFSET(INDIRECT(cell),0,0,1,1)) where cell refers to a cell containing a XLS name because the filename and path change monthly. When I open the main file all my cells containing the above formula show "#REF" until the spreadsheets it's referring to are open. I have a macro that automatically opens all the referring spreadsheets ~12 files. Shouldn't Excel take a snapshot of the data once I save the main file? I want to be able to view the data as it is without opening the 12 files it's referring to. Is it possible? Any other approach is welcome. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is there a workaround with #REF error message?
Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/ That includes =indirect.ext() that may help you. matelot wrote: I have a spreadsheet that uses extensively OFFSET(INDIRECT(cell),0,0,1,1)) where cell refers to a cell containing a XLS name because the filename and path change monthly. When I open the main file all my cells containing the above formula show "#REF" until the spreadsheets it's referring to are open. I have a macro that automatically opens all the referring spreadsheets ~12 files. Shouldn't Excel take a snapshot of the data once I save the main file? I want to be able to view the data as it is without opening the 12 files it's referring to. Is it possible? Any other approach is welcome. Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace VBA run-time error message with custom message | Excel Programming | |||
| error message: compile error, argument not optional | Excel Programming | |||
| Excel XP error message Run Time Error 91 | Excel Programming | |||
| changing the message in an error message | Excel Worksheet Functions | |||
| How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Linear Mode
