Re: How do you link shared spreadsheets and reference certain cells

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/07/04 

Date: Sun, 7 Mar 2004 21:41:31 +0100

Hi Eddie
what error did you get?
One possible workaround:
1. Open this 04Timecard.xls workbook
2. Now enter the formula
=SUM('[04Timecards.xls]Linda'!C2:C10)
or simply enter =SUM(
and select the approbiate range on the other workbook.
3. Close the other workbook and test if SUM still works (and what path
is inserted by Excel) 

--
Regards
Frank Kabel
Frankfurt, Germany
Eddie wrote:
> I replied to an eartlier post and didn't want it to get
> buried so reposting. Sorry if breaking etiquette.
>
> How do you do a sum? I am getting errors with this:
> =SUM('\\share\ACCT[04Timecards.xls]Linda'!C2:C10)
> I have tried moving the quotes, changing to dbl quotes,
> removing them altogether with no luck. The file is on a
> shared drive, not mapped. Maybe it has to be a mapped
> drive? It is on a local PC that another PC has to
> reference to.
> Thanks!
>
>> -----Original Message-----
>> Hi
>> are you looking for linking individual cells. If yes use something
>> like the following formula
>> ='path_name\[workbookname]worksheetname'!cell_reference
>> e.g
>> ='C:\temp\[test_wbk.xls]sheet1'!A1
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>> Rakesh wrote:
>>> How do I link two excel files so that I can use the data
>>> stored in both the files?
Quantcast