What happens often is that one person will have one of these spreadsheets open and the other spreadsheets linked to the subject spreadsheet closed and decide to insert a column that throws off the references of the closed linked spreadsheets. If the person knew which spreadsheets were linked to it, the person could open them before inserting the column and avoid throwing off the links.
I’ll bet I don’t have two workbooks with external links. I have a ton with external data queries, but not external links. I don’t have any problem with linking to other workbooks (I don’t think), but I must like my workbooks to be self-contained or something.
It seems the problem is with closed workbooks that contains formulas that link to open workbooks. That is a problem since the open workbook doesn’t know which other workbooks link to it. Ideally, a commandbar that lists all the dependent workbooks and a button that says ‘All’ which opens them up. (Commandbars, or toolbars, or those user interface constructs that existed before the Ribbon).
Is this a problem for everyone? How do you solve it?