How do you link shared spreadsheets and reference certain cells

[Eddie]

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

How do I link two excel files so that I can use the data
stored in both the files?

 

[Frank Kabel]

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

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

How do I link two excel files so that I can use the data
stored in both the files?

 

[Eddie]

Thanks Frank that did it! It seems like I had entered that
formula before.... For anyone follwing here's what it came
up with:
=SUM('\\Sharename\ACCT\[04Timecards.xls]Linda'!C2:C366)

-----Original Message-----
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

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?

.