Linking two excel files

  • Thread starter Thread starter Rakesh
  • Start date Start date
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
 
Or open both files, type

=

select the cell in the other workbook and press
enter

that way you would get path etc for free once you close the workbook(s)

--

Regards,

Peo Sjoblom

Frank Kabel said:
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?
Click to expand...
Click to expand...
 
How do you do a sum because 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?
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?
Click to expand...

.
Click to expand...
 
Back
Top