S
Shaffiqe
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
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