Cell Reference
 

I have a spreadsheet with phone list/area responsibility information. There
is a Landscape version and a Portrait version. The Portrait version is locked
and password protected because any changes should be made in the Landscape
version. Changes are automatically updated. I did some formatting changes and
rearranged some cells, and now the formulas I used do not work.
Some cells use =SUM('Landscape Ver.'!B6:B7)
and some cells use ='Landscape Ver.'!B4:B5

and they work. Others have 0 or Value!. Even if I try and redo the formulas,
they don't work.

Please help!

Thanks.
M