Open both workbooks.

Edit|Copy AA6 of that "sending" worksheet.

Find where you want it to be placed in the "receiving worksheet"

edit|paste special|paste link

When you close the sending workbook, you'll see that excel adjusted the formula.



Danedel wrote:

I'm having trouble linking to a closed workbook. I want to update information
from that book to another book and am certain I have entered the correct
formula, at least according to Excel's help section, yet I get error
messages. Here's the formula:

=(€˜S:\office\Maint. OT 2006[JAN 2006 OT FORM.xls]JAN OT Tracking Chart
2006!AA6)

I'm not computing anything, just referencing data from a single cell.
Anyone's help would be greatly appreciated. Thanks.

--

Dave Peterson