how do i solve 'file not found' error when linking notebooks?

G

Guest

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.
 
D

Dave Peterson

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!)
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I keep getting supscript out of range error how do I solve? 5
Receive Error File Not Found 1
Debugger error: symbol file could not be found 2
Outlook connector crashes outlook 0
Outlook crashes with Outlook connector 2002 0
How do I get rid of an "GWXL97.xla file not found" error that pre. 1
How do I fix a Service Control Manager Error (Category 7000) - file not found 0
How do I fix a Service Control Mnaager Error (Category 7000) - file not found 1

Top