Solved

Excel 2013 refuses to show new cell styles and value until workbook is saved, closed and reopened

Posted on 2013-12-17
8
148 Views
Last Modified: 2014-10-23
Hi all

As stated in the title, I have a client running Excel 2013 with some workbooks, she's noticed that when modifying a cell (adding a value, border, fill, or any sort of style), nothing shows up. The cell appears to remain unchanged until she saves her file and then reopens it, at which point cell values and styles become visible. I understand this doesn't happen with every workbook, but a considerable number of them. She first noticed the issue happening on the 19th of November. She's running Windows 7 Professional 64-bit, her Office architecture is 32-bit.

Any help would be greatly appreciated
0
Comment
Question by:systembridge
8 Comments
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
Comment Utility
What happens if the user does an F9 to re-calc when the user sees the problem?

Also try doing an Office Repair from Control Panel. Do the full repair if it asks.

.... Thinkpads_User
0
 
LVL 14

Expert Comment

by:Geisrud
Comment Utility
File > Options > Formulas
In the "Calculation Options" section, is workbook calculation set to "Automatic?
0
 

Author Comment

by:systembridge
Comment Utility
Thinkpads_User:
I've asked the client to try pressing F9 to see if that remedies things.  I've also performed a repair of Office. On both, I have yet to hear back. Sorry for taking so long to get back to you.

Geisrud:
As stated above to Thinkpads_User, I've asked and have yet to receive any response from the user.

Thank you both for your responses. Once I hear back, I will update the answer.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
@systembridge - Thanks and please let us know. Thanks.

... Thinkpads_User
0
 

Author Comment

by:systembridge
Comment Utility
As I've heard nothing more of the issue, I'll be closing the question. Thank you both for your insight. It would appear as though a repair installation of Office has remedied the issue. Or at least it has for us.
0
 
LVL 45

Expert Comment

by:Martin Liss
Comment Utility
I've requested that this question be closed as follows:

Accepted answer: 0 points for systembridge's comment #a39812730

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
I suggested in http#a39725416 that an Office Repair be tried. Systembridge confirmed that a Repair worked.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now