Hyperlink from one.xlsx cell to another two.xlxs cell & click back

[Bobbi-Joe]

I want to know if it is possible to Hyperlink from one file>worksheet>cell to
another file>worksheet>cell. I am trying to link two seperate files
(workbooks) to each other, one being account's payable and the other energy
consumption. Two large files (don't want to put them together - b/c it gets
too complex)

One sheet to summarize all information that can be hyperlinked to other
Files information.

 

[Dave Peterson]

Hyperlinks to another workbook would open that second workbook. Is that what
you want?

I'm guessing no.

If you want to retrieve a value from a cell in that second workbook:
Open both workbooks.
Traverse to the cell that you want to retrieve
Edit|Copy (or ctrl-c)
Traverse to the receiving cell.
Edit|Paste special|paste link

Excel will adjust the formula for you when you close the sending workbook.