I have an excel macro-enabled workbook, call it "seating plans", that refers to a data table in a separate workbook. It does so both through pivot tables and in formulas.
Sometimes it asks to update links when I open it. Sometimes it doesn't. It doesn't seem to matter if the data table worksheet is open or not when opening the seating plans workbook.
Is there any rationale to this?!