I was wondering:

Say I have a excel document with data in the library.
Can I have that data displayed in a word document also in the library.
(And updated when excel data changes)

OR do I have to have the excel data stored in another common storage area?

Simply put; can I refer to a document in the library?