• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1326
  • Last Modified:

Formula bar display - data is there but not visible

My excel 2013 suddenly stopped displaying the values or formulas in the formula bar.  The data or formula associated with a cell are there, just cannot be seen.  You can select the info in the formula bar and then paste it into another cell, which will then display.  I can click in the cell and edit, but still nothing visible is displayed in formula bar.

Looked here and in other forums for a solution.  I've checked to make sure "hidden" and "protection" of the cell or sheets are not selected incorrectly.  I am using a multiple display, but switching back to single did not resolve the issue.  I've expanded the formula bar and looked for any line returns.  I've removed the formula bar and added it back.  I've tried to change the font and font color of the contents of the formula bar.

It is affecting all the worksheets I have open, not just one.  I have looked through the "File\options" for any settings I may have inadvertently changed but without success.

Any help would be appreciated!
0
wineybob18
Asked:
wineybob18
  • 4
  • 4
  • 3
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
this can happen if the cell is protected and Protect Sheet is on.  Here is an article with a remedy:
https://support.office.com/en-us/article/Display-or-hide-formulas-f7f5ab4e-bf24-4efc-8fc9-0c1b77a5356f
0
 
Martin LissRetired ProgrammerCommented:
Or press CTRL + ` (grave accent)
0
 
wineybob18Author Commented:
Thanks for your quick response!  However, I have tried that and it didn't work.  I went through your link again to make sure and still got no change in my display of the formula bar.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
Martin LissRetired ProgrammerCommented:
Did you see my post?
0
 
wineybob18Author Commented:
Yes, thank you.  I tried that as well with no results.  The formula display is still not visible.
0
 
Martin LissRetired ProgrammerCommented:
Does the problem affect all workbooks or just this one? If just this workbook then try importing one of the sheets into a new workbook. If that sheet shows formulas then import all the sheets and replace the old workbook.
0
 
wineybob18Author Commented:
The problem began right after I changed a table in one sheet back to a range.  This workbook has 20+ sheets.  It was occurring in all sheets in the original workbook as well as two other workbooks open at the time. I replicated the same issue in a new workbook as well.  I tried closing and reopening the workbooks too.
0
 
Martin LissRetired ProgrammerCommented:
Please post a sample workbook that demonstrates the problem.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
out of curiosity, have you rebooted the computer since this happened? Hopefully Excel will bounce back ~
0
 
wineybob18Author Commented:
Duh! Good ole reboot did the trick.  I was so sure I had inadvertently changed something that I neglected to try one of the best tech support methods.
Thanks for suggesting it.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now