Thanks Luke,

For number 1, does it mean I need to open the workbook and use indirect
function to link the cell from workbook 1 to workbook 2, which will indicate
like "='M:\Payroll\Expenses Report\[NON-
GATE REPORT APR 2010.working.xls]APR 10'!$G$38"?

For number 2, I did hit the F4 key on every cell, but if there any option
that I don't need to hit the F4 cell by cell in case of over 100 cells to
work on?

Regards,
Terry



Luke M wrote:
For number 1, I'm afriad you're probably out of luck. The closest thing
would be the INDIRECT function, but it won't work on closed workbooks. You
could use the HYPERLINK function, and concatenate a string together, but
that would simply open the file, not retrieve the specific data.

For number 2, did you try and type the dollar signs? Alternatively, after
clicking on the cell, hit the F4 key. This cycles through the different
options for relative/absolute referencing.

Hi,

[quoted text clipped - 16 lines]
Many Thanks
Terry

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1