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

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
systembridgeAsked:
Who is Participating?
 
JohnConnect With a Mentor Business Consultant (Owner)Commented:
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
 
GeisrudSystems AdministratorCommented:
File > Options > Formulas
In the "Calculation Options" section, is workbook calculation set to "Automatic?
0
 
systembridgeAuthor Commented:
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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
JohnBusiness Consultant (Owner)Commented:
@systembridge - Thanks and please let us know. Thanks.

... Thinkpads_User
0
 
systembridgeAuthor Commented:
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
 
Martin LissOlder than dirtCommented:
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
 
JohnBusiness Consultant (Owner)Commented:
I suggested in http#a39725416 that an Office Repair be tried. Systembridge confirmed that a Repair worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.