A spooky sheet - all zero values

[ernie37]

pI have a sheet in my workbook where every computed value is entered into a cell as “0” even though when I use the function tool to check the function, the correct value is shown. It happens with every cell on the sheet. ????

One clue. This sheet was imported from another workbook. To break the links to the other workbook I used the trick of replacing all of the “=“ characters with something else, importing the sheet, then putting the = characters back in.

But, according to the function tool, the equations get the correct values!

Here is just one example of a function that gives the correct result in the tool,but puts 0 (zero) into each cell where is is used:

=IF(Parameters!R[6]C[-1]<>””,Parameters!R[6]C[-1],””)
ps ANYTHING with an equal sign (e.g., =5*6) gives a zero in the cell ????

Anybody have any ideas about what is going on on this sheet that makes it refuse to accept computed values??

 

[par60056]

it looks like you are using relative addressing onto another sheet. Is this really what you want it to do?

What is on the sheet "Parameters" and what cell is this formula is?

More information is required to solve the problem.

 

[ernie37]

Yes. I have other workbooks with this sheet and these equations work fine. I have now isolated the problem to the “=“ sign. This has something to do with the way I broght the sheet over from the other workbook.

-> If I type 6 in a cell it puts 6 there. If I type =6 in the cell it puts zero there.

Let’s focus on that issue and forget the formulas for now. There is nothing about the formulas that is causing this problem. It has to do with the fact that suddenly “=“ in this sheet no longer has the same function it normally has. ???

 

[ernie37]

Re: A spooky sheet - all zero values [SOLVED]

Yes. I have other workbooks with this sheet and these equations work fine. I have now isolated the problem to the “=“ sign. This has something to do with the way I broght the sheet over from the other workbook.

-> If I type 6 in a cell it puts 6 there. If I type =6 in the cell it puts zero there.

Let’s focus on that issue and forget the formulas for now. There is nothing about the formulas that is causing this problem. It has to do with the fact that suddenly “=“ in this sheet no longer has the same function it normally has. ???

My solution was to just create an entirely new sheet and copy the formulas over. The “=“ characters came across fine. Something weird happened when I did the substitution when I copied this sheet over the first time??? So, beware when copying a sheet from another workbook and using the trick of substituting characters for the “=“s to break the link to the workbook, and then replacing the substituted character with “=“s again!