?
Solved

Formula bar display - data is there but not visible

Posted on 2016-09-23
11
Medium Priority
?
427 Views
Last Modified: 2016-09-24
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
Comment
Question by:wineybob18
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 3
11 Comments
 
LVL 22
ID: 41813196
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
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41813199
Or press CTRL + ` (grave accent)
0
 

Author Comment

by:wineybob18
ID: 41813205
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 49

Expert Comment

by:Martin Liss
ID: 41813207
Did you see my post?
0
 

Author Comment

by:wineybob18
ID: 41813295
Yes, thank you.  I tried that as well with no results.  The formula display is still not visible.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41813310
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
 

Author Comment

by:wineybob18
ID: 41813322
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
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41813391
Please post a sample workbook that demonstrates the problem.
0
 
LVL 22

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 2000 total points
ID: 41813396
out of curiosity, have you rebooted the computer since this happened? Hopefully Excel will bounce back ~
0
 

Author Comment

by:wineybob18
ID: 41813732
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
 
LVL 22
ID: 41813865
you're welcome ~ happy to help
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question