Re: Can I show server name instead of drive letter?

From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 02/15/05


Date: Mon, 14 Feb 2005 19:10:25 -0600

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