I am using Mac Excel 2004. I have rows and columns

of numbers using formulas. Everything has been

working properly until now, when I changed the

formula to have the numerical data in a cell in one

worksheet be the data that comes up in the cell in the

other. All I did was change the cell number that the

data is to come from. I have checked and rechecked

numerous times but cannot find any reason why it

suddenly stopped coming up with the right number

and comes up with zero instead. This is happening

now in all the cells in this row except for one. I can

see nothing different in the configuration of this cell

from the others. It doesn't matter now what formula I

use in these cells, the answer always comes up zero.

Could Formatting be the problem? MIKE

Same exact formatting as in the cell that works.

Did you specify it was coming from another different sheet? MIKE

Yes I did. But the cells also are not working when I try any

other formula now. The answer is always 0.

2 suggestions: 1 - The standard one: It's kind of hard for us to help based on the limited info you have provided. Basically you are telling us that you had a formula that worked, you changed it and now it doesn't work. You're not giving us very much to work with.

Perhaps if you posted the before and after, that might help.

2 - Have you tried the "Tools...Formula Auditing...Evaluate Formula" feature?

This will allow you to step through the formula and see the results of each part of the formula one by one. I have found this feature invaluable for both troubleshooting and for understanding formulae that I find in worksheets.

Based on your latest response, it's very possible that you have a corrupt worksheet. You can try copying various sections of the worksheet into a new one, avoiding the problem row, and then manually entering the data that you avoided.

You'll obviously run into some errors and bad results during the process, but you might end with a clean worksheet when you are all done.

BTDT

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History