Perhaps this exists and I've just never seen it, but it appears to me that
there is a need for a list of worksheet functions that only work when
referencing data within the workbook they are used in and do not work across
workbooks when the other workbook is not also open.

Also, each of those functions should have an annotation of the limitation in
its HELP topic. And to be really helpful, an example of a workaround would
be great.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions