Updating Indirect with Closed Workbook

I have all my formulas working in BrianSummary.xlsx but they will only updated if the workbook it is linked to (brianformulas.xlsx) is open as well. I need a way to have my formulas update within having to open up brianformulas.xlsx

The formulas that have this link are in BrianSummary.xlsx Cells B4:X4 and B6:X6 and these are the formulas currently

=IF(SUMPRODUCT(SUMIF(INDIRECT("'[BrianFormulas.xlsx]"&list&"'!$A$2"),$A$2,INDIRECT("'[BrianFormulas.xlsx]"&list&"'!b$4")))=0,"",(SUMPRODUCT(SUMIF(INDIRECT("'[BrianFormulas.xlsx]"&list&"'!$A$2"),$A$2,INDIRECT("'[BrianFormulas.xlsx]"&list&"'!b$4")))))

and

=(SUMPRODUCT(SUMIF(INDIRECT("'[BrianFormulas.xlsx]"&list&"'!$b$4"),$B$4,INDIRECT("'[BrianFormulas.xlsx]"&list&"'!b$14"))))

Thank you for the help, have to be at work in 2 hours with this completed. Really appreciate it guys

Hello

I'm not 100% sure but where you have your Indirect part of the formula I think you need to reference the entire path of the work book.

So instead of "[BrianFormulas(1).xlsx]" you would need to have "'C:\Desktop\[BrianFormulas(1).xlsx]" or whatever the path is.

Hope this works/helps

Cheers

Jim

******Update********

Just looked around on tinternet, it doesn't look like the INDIRECT formula will ever work on a workbook that is not open.

So I dont think this will be possible with this type of formula

Sorry

Jim

I have another question regarding the link. The two worksheets i was working on were basically just practice with the actual one i need to link the data to an excel document that we keep online, the address is

http://finance-team/Daily Monitoring Tools/Bank Balances/Cash Balance Asia + ANZ 2011.xlsx

how do i incorporate this into the equation? Do I just replace

[BrianFormulas.xlsx] with http://finance-team/Daily Monitoring Tools/Bank Balances/Cash Balance Asia + ANZ 2011.xlsx

and this is about equation in b4:x4

=IF(SUMPRODUCT(SUMIF(INDIRECT("'[BrianFormulas.xlsx]"&list&"'!$A$2"),$A$2,INDIRECT("'[BrianFormulas.xlsx]"&list&"'!b$4")))=0,"",(SUMPRODUCT(SUMIF(INDIRECT("'[BrianFormulas.xlsx]"&list&"'!$A$2"),$A$2,INDIRECT("'[BrianFormulas.xlsx]"&list&"'!b$4")))))