Respected members,

I need help in the following situation:

I have made some files say "Business-1" , "Business-2" ,
"Business-3" , and "Consolidated" .

I have written a formula in "Consolidated" cell A10 to
sum-up all the figures in cell A10 of Business-1,2& 3.

When I open the file Consolidated and go to the cell
A10, the formula bar does not gives the reference to
the cell A10 of Business-3, untill i also open any of
the files namely Business-1, business-2 or business-3.

Notably, despite the formula bar display issue the
cell A10 in "Consolidated" calculates the sum
correctly in either conditions.

Please tell me, how it happens, is it a virus, does my
computer needs scanning, or there is some purely excel
issue ???

Regards,

Shafique Bhatti
Lahore