R
Reinhard
I have two files i use a formula and count some informaton.
Since i made some more entires it show the error message in the attachement
What can that be
it is a lrge file about 8000 lines with 24 collums. but is this to large ?
Formula =COUNTIF(DATA!$F$2:$F$8469;(B48&"x"&C48))
in the Cell DATA$F$2:$F$8469 is this formula
=IF('E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!U2=$E$1;IF('E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!T2=0;'E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!M2&"x"&'E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!N2&"x"&'E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!O2;"null"))
Anybody can help me Thanks
Error mesagge again
Axcel can not complete that task with available Resccource Choose less data
or close other applications
Data : i have what i have
other programms different computer no other programms running .. no change
Since i made some more entires it show the error message in the attachement
What can that be
it is a lrge file about 8000 lines with 24 collums. but is this to large ?
Formula =COUNTIF(DATA!$F$2:$F$8469;(B48&"x"&C48))
in the Cell DATA$F$2:$F$8469 is this formula
=IF('E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!U2=$E$1;IF('E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!T2=0;'E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!M2&"x"&'E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!N2&"x"&'E:\Documents and Settings\RS\My
Documents\Inventory\[Timberstocklistactually
test4.xls]INVENTORY'!O2;"null"))
Anybody can help me Thanks
Error mesagge again
Axcel can not complete that task with available Resccource Choose less data
or close other applications
Data : i have what i have
other programms different computer no other programms running .. no change