Discussion Locked

Excel formula bar blank

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I have two users who have an intermittent problem with the formula bar in excel(office 2000). Some days they see the data of the selected cell and other times they do not see it. I have tried to find a common denominator but so far nothing.
Any ideas?
Thanks!

2 replies

by Member 19528012

Are you sure the cell properties are not set to hidden and the sheet is protected (under tools menu)

This causes the formula bar to not show the value.

by suzanne.harvey

Thanks for your response. No, the sheet is not protected and the cells are not hidden. I think this is a bug because it happens on and off. This morning the user worked on a sheet with no problems, she reopened it this afternoon and the formula bar shows blank. If I open a new sheet, it's still blank. If I open a second session of Excel, the formula bar works, but when I closed the first session and reopened it, the formula bar was blank. Very strange.
I have a feeling it might be connected to one specifc worksheet that maybe affects Excel. I don't know for sure. Thanks for your help anyway. I appreciated it.

This discussion is closed to new replies.