i'm trying to link together different workbooks in excel. this is a formula
i am using, but still get 'file not found' errors when it looks for the other
workbooks to link to.

=IF('C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C$75=0,"0",'C:\BENPROJ\1997\wkshts\[BM6-97.XLW]A'!$G$114*
('C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C79/'C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C$75)+'C:\BENPROJ\1997\wkshts\[BM1-97.XLW]SL New'!C79)

mainly it's this:
'C:\BENPROJ\1997\wkshts\[BM6-97.XLW]A'!$G$114*
('C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C79/'C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C$75)+'C:\BENPROJ\1997\wkshts\[BM1-97.XLW]SL New'!C79
unless my if stmt is wrong.

thanks.

Are you saying that you think the files are actually there, but excel can't find
them?

If you are, then I think you made a typo.

When I'm building those kinds of formulas, I'll let excel do the work.

I'll open all the workbooks I need, then I'll start my formula:

=if(

Then I'll use Window to go to the other workbook, then go to the correct sheet
and click on the cell I want to retrieve.

Then continue the formula the same way.

Excel will make sure the syntax is correct--at least for the part it builds.

When you close the other workbooks, excel will adjust the formulas to include
the drive and path.

(I don't think I'd ever try typing one of these monster formulas!)

bmorar wrote:

i'm trying to link together different workbooks in excel. this is a formula
i am using, but still get 'file not found' errors when it looks for the other
workbooks to link to.

=IF('C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C$75=0,"0",'C:\BENPROJ\1997\wkshts\[BM6-97.XLW]A'!$G$114*
('C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C79/'C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C$75)+'C:\BENPROJ\1997\wkshts\[BM1-97.XLW]SL New'!C79)

mainly it's this:
'C:\BENPROJ\1997\wkshts\[BM6-97.XLW]A'!$G$114*
('C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C79/'C:\BENPROJ\1997\wkshts\[BM1A-97.XLW]SL
New'!$C$75)+'C:\BENPROJ\1997\wkshts\[BM1-97.XLW]SL New'!C79
unless my if stmt is wrong.

thanks.

--

Dave Peterson