MISSING import external data from Excel to Excel
 

Excel version 2002
Excel file name "Book 1" : have password to open & Edit & worksheet protection

Book 1 sheet 1 Columns H have IF formula

I opened Book 1(Excel) and Book 2 ( Excel )
at Book 2 import external date from Book 1 sheet 1
then at Book 2 some of the cell DON'T NOT have data from Book 1 sheet 1 ,
like columns H , all is blank

and the other cell like Book 1 row 7 all is the same formula
But at Book 2 just some of the row 7 cell is come out the result from Book 1

Any one can help me ???

Thanks