Disappearing act

[321Fred]

Two days ago I opened a spreadsheet I've been working on over the past year and found that on a certain tab sheet a formula result that used to display a continued updated result based on amounts spent and documented on other sheets just disappeared. The formula is there but the result just wont display unless I remove the equals sign in front of it. I can type text in the cell and it will show just not the formula !
I've tried erasing it, retyping it, clearing any formatting of the cell, tried changing the colors to make sure the text wasn't the same color as the back ground, I verified the cell was supposed to show the answer as currency. Nothing has rectified the problem.

Has an one come across this before?

 

[Jeffrey Mahoney]

Have you tried putting the same formula in a cell on a new sheet?

When you highlight sections of the formula, results will show above. You need to highlight logical breaks in the formula, like an entire VLOOKUP() function. Do you get results?

 

[321Fred]

No I haven't tried that but will now.

 

[321Fred]

What in the heck is going on !!!!!!!!!!!!! I tried to fix this issue all day yesterday and up till a half hour ago with no progress. I just reopened that page and now that cell is once again showing the result as expected (out a the blue ) again. ? I'm starting to think Excel may beginning to have a mind of its own !

But thank you for trying to help - I just have absolutely no idea or reasoning to explain what is going on !

 

[Jeffrey Mahoney]

Excel does have a mind of it's own. Do you think you're in control?

 

[Joe4]

It is amazing how many things computer/electronic related can by fixed by closing/re-opening/re-booting!
When in doubt, re-boot!

 

[Jeffrey Mahoney]

Now that cars are run by computer, are we going to have to pull over to the side of the road, reset the computer, and then continue our trip?

 

[Joe4]

Now that cars are run by computer, are we going to have to pull over to the side of the road, reset the computer, and then continue our trip?

If they ever let us reset the computer ourselves!