Array formula to work when value imported from another workbook

[Spl1t1]

I have 7 workbooks that import into another workbook. In the master workbook on sheet 1 I have some array formula's and lookup formula's importing from another worksheet on the master workbook. When I type in the value's in the worksheet, they populate over to the master worksheet, but when I have the value's update from another workbook, the array formula and the lookup formula don't produce any data. The array formula on the master worksheet of the master workbook looks like this.

=IF(COUNT(SSA!C7:G18),LOOKUP(1E+100,INDEX(SSA!C7:G18,MAX(IF(SSA!C7:G18<>"",ROW(SSA!C7:G18)))-ROW(C7)+1,0)),"")

The formula on the 2nd worksheet int he master workbook looks like this.

='C:\Documents and Settings\mark10\Desktop\NRO\Philly & NJ\NRO Financials\Phil''s weekly P&L\[Langhornep1.xls]P&L'!$B$188

Please help.

 

[Spl1t1]

So I found that it does still work, I just have a problem. When I update the value for the other workbook, if there is nothing in the cell, it displays a 0 in the cell. Then in the master worksheet in the master workbook displays 0. I need it so that it only displays the value that is entered into the worksheet, even if it is a 0.