Indexing on Closed Workbook

[jamesmev]

I have written a path to a closed workbook. However it will run the index unless the file is also open.
The file takes to long to load and needs to stay closed and allow to be searched in the background.

Please help here is the code that shows when the workbook is open.

=IFERROR(INDEX('Copy of Equipment_Active_Outlets.csv'!$C$2:$C$999999, SMALL(IF($C$3='Copy of Equipment_Active_Outlets.csv'!$A$2:$A$999999, ROW('Copy of Equipment_Active_Outlets.csv'!$A$2:$A$999999)-ROW('Copy of Equipment_Active_Outlets.csv'!$A$2)+1), ROW('Copy of Equipment_Active_Outlets.csv'!1:1))),"")

But...
This is what is shows when it is closed:
=IFERROR(INDEX('R:\Targeted Sales\Targeted Sales General\Customer 1\[Copy of Equipment_Active_Outlets.csv]Copy of Equipment_Active_Outlet'!$C$2:$C$999999, SMALL(IF($C$3='R:\Targeted Sales\Targeted Sales General\Customer 1\[Copy of Equipment_Active_Outlets.csv]Copy of Equipment_Active_Outlet'!$A$2:$A$999999, ROW('R:\Targeted Sales\Targeted Sales General\Customer 1\[Copy of Equipment_Active_Outlets.csv]Copy of Equipment_Active_Outlet'!$A$2:$A$999999)-ROW('R:\Targeted Sales\Targeted Sales General\Customer 1\[Copy of Equipment_Active_Outlets.csv]Copy of Equipment_Active_Outlet'!$A$2)+1), ROW('R:\Targeted Sales\Targeted Sales General\Customer 1\[Copy of Equipment_Active_Outlets.csv]Copy of Equipment_Active_Outlet'!2:2))),"")


PLEASE HELP!

 

[godsaaint]

If the workbook is closed, the formula needs to have the entire path of the file, just as you showed in the second formula. That one is not working?

 

[jamesmev]

Correct. I do have the path written complete as in the second example but It won't reference the file.
It is giving me the check data and refresh error.

When I do open the file it converts the code to what I first pasted which then works.

I need to avoid opening the file.

 

[godsaaint]

Save the csv file as an excel file (xls) and try again. it should work then. Since csv are basically text and commas, locations may not exist in them.

 

[jamesmev]

I changed the file to a xlsx and now even entering the path freezes Excel to (Not Responding)
i think the referenced workbook is so large. I can't get passed entering the formula and it freezes and I have to restart each time.