Linking problem

sdcamp3020

Board Regular
Joined
Mar 5, 2008
Messages
54
I have a worksheet that is linked to pull data from my quote log based on the job number listed in cell F6. I have successfully linked the files and am able to pull my Customer Name and Purchase Order Number every time with no problem. However, when I try to pull the quote amount I get the #REF answer unless I open the Quote Log (the formula works fine when the quote log is open). I have typed the formula manually to make sure that it is correct and it still will only work if the quote log is open.

This is the formula I am using to pull the Purchase Order Number (works):

=IF(INDEX('\\server03\E\LOGS\QUOTE LOG.xls'!PO_NO,MATCH(F6,'\\server03\E\LOGS\QUOTE LOG.xls'!RECORD))=0,"",INDEX('\\server03\E\LOGS\QUOTE LOG.xls'!PO_NO,MATCH(F6,'\\server03\E\LOGS\QUOTE LOG.xls'!RECORD)))

This is the formula I am using to pull the quote amount (works only if quote log is open):

=IF(INDEX('\\server03\E\LOGS\QUOTE LOG.xls'!QUOTE_AMT,MATCH(F6,'\\server03\E\LOGS\QUOTE LOG.xls'!RECORD,0))=0,"",INDEX('\\server03\E\LOGS\QUOTE LOG.xls'!QUOTE_AMT,MATCH(F6,'\\server03\E\LOGS\QUOTE LOG.xls'!RECORD)))

Any suggestions on what is going wrong?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

sdcamp3020

Board Regular
Joined
Mar 5, 2008
Messages
54
Problem solved! I have been getting an error message stating that "Excel cannot complete the current task. Not enough resources are available."
A friend suggested this might be the problem so I went to my source workbook and reduced the size and then my link started working. Thanks.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,951
Messages
5,834,547
Members
430,295
Latest member
amdis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top