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?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,052
Members
414,357
Latest member
Gemma_R

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