| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating Indirect Reference(s)
I have a workbook with indirect references for vlookups into other workbooks.
The indirect reference is not recognized as a link when I open the spreadsheet and does not update. I must open the referenced spreadsheets for the vlookup to work. This is monthly budget data, so by December I'll be opening 72 workbooks (and Enabling macros for each one). Any way to have the indirect reference be seen as a link? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External cell references using INDIRECT & ADDRESS | Excel Worksheet Functions | |||
| Can you use INDIRECT in 3-D references? | Excel Worksheet Functions | |||
| Trick? for using INDIRECT references in Data Source of Chart? | Charts and Charting in Excel | |||
| Using Indirect en direct cell references | Excel Discussion (Misc queries) | |||
| Indirect references in a linked formula | Excel Worksheet Functions | |||
Threaded Mode
