# A spooky sheet - all zero values

#### ernie37

##### New Member
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??

Last edited:

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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?

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. ???

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!

Replies
0
Views
514
Replies
17
Views
3K
Replies
7
Views
2K
Replies
10
Views
5K
Replies
12
Views
501

1,203,094
Messages
6,053,505
Members
444,667
Latest member
KWR21

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back