And you may want to make your formula look more like:

=cell("filename",a1)

Otherwise, your formula will evaluate to the last workbook that was calculated.

You can see this if you have the same formula in A1 of sheet1 of two separate
workbooks.

Window|arrange|horizontal

(Save both workbooks and look at each of the cells after each save.)

bfant wrote:

When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?

--

Dave Peterson