Cell Reference

C

chickalina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resizing/Rescaling an Org Chart 0
correcting #value! problem 4
I have either a H or A in cell B5. 2
Printing Userforms [Landscape] 1
if true, if not nested if funcion 2
Issues when deleting cells with multiple versions of Excel 0
increment cell reference in a formula 3
Problem with margins while printing via network 0

Top