Sunrise TG <Sunrise wrote
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?

If you mean you're using the INDIRECT function to refer to ranges in
other workbooks, then there's no way to make them work unless *ALL*
the other files are open. Why are you using indirect links? It may be
easier to use, er, direct external reference links which wouldn't
require that the other workbooks be open.

Give a few examples of these formulas. There may be workarounds.