You can write formulas in the open workbook that refer to the cells in the 2nd
workbook, regardless of the number of worksheets it contains. This creates a
"link" from workbook #1 to #2.

If #2 isn't open when you open #1, you'll be asked whether to update the
information from #2. This will happen without you seeing #2 appear on the
screen.


On Sat, 5 Mar 2005 15:33:03 -0800, "GrayesGhost"
wrote:

If an unopened Excel Workbook only contains a single worksheet, is it
possible to import the data from that worksheet into another Workbook that is
open, without having to open the other file?