Is there something obvious I'm missing here??! Please help.
Posted by andrew miller on January 16, 2002 2:11 PM
I have a cell that references a cell in a worksheet within the same workbook. It is a very simple formula. it simply is =(sheet next to it)(cell). It works fine in the cell that it is in. My problem is that if I try to enter that same formula into a cell in any columns to the right or left, it returns a #value! error. It makes absolutely no sense. I have manually typed it in, I have copied and pasted. Nothing works. It is the same thing anywhere on the page. I created a new worksheet and entered the same formula referencing the same cell I get the same error. So either I am missing something very obvious or I think I have a corrupted file. Any thoughts?