Solved

Excel Going Black

Posted on 2014-10-03
7
359 Views
Last Modified: 2014-10-09
I have a few users who are having an issue with Excel spreadsheets. They mainly deal with spreadsheets from Cisco, such as the pricing tools which only use .xls not xlsx. They are all running in compatibility mode as Cisco doesn't accept .xlsx on their site.   do not believe they are running macro's.

At random times, these users will experience all of their Excel spreadsheets going black that are open. Not that the cells are being formatted differently, but as if Excel has crashed or is just not able to display the data. If we close them through task manager, they reopen and look fine.

We have not seen a commonality to when this problem happens, but seems random at this point and will occur several times a day.

Any help in narrowing the problem down would be a huge help!
0
Comment
Question by:Awesome Itguys
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40359709
i have a feeling this is a duplicate question. i must have seen this before. or perhaps Déjà vu
0
 
LVL 27

Assisted Solution

by:Glenn Ray
Glenn Ray earned 250 total points
ID: 40359797
Is the behavior similar to the examples shown in this EE thread?

Excel lines turning black

If so, I agree with the solution that teylyn suggested:  there are likely workstation-specific issues.  It could be hardware (ex., graphics cards) or software (ex., Service Pack updates).

-Glenn
0
 

Author Comment

by:Awesome Itguys
ID: 40359935
My last one was closed by the site admin, so I had re-posted to get it back up and view-able.

I did see that post, and it is somewhat similar in terms of the black screen, but it doesn't come back with scrolling/clicking like in that thread.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 4

Accepted Solution

by:
C. Blaise Mitsutama earned 250 total points
ID: 40362404
When troubleshooting, you can't assume anything. This is how I would go about troubleshooting this issue:

1. You stated "I have a few users who are having an issue with Excel spreadsheets."
     a. Is the problem limited to those who use the Cisco files or do non-Cisco Excel files ever show this problem? If you're not sure, have the users open/modify/close several non-Cisco files throughout the day to see if the problem can be replicated.
2. What version of Excel is used by those having the black screen problem?
3. Do you know what version of Excel was used to create the Cisco tools?
4. Are all affected users on the same version of Windows? If so, what version is it? 32-bit or 64-bit?
5. What happens if files are saved as .xlsx files without Compatibility Mode? (I understand that Cisco doesn't accept .xlsx on their site, but this is for troubleshooting purposes only.) If the files work as .xlsx files, it may be possible to update the files as .xlsx, then save the files as .xls using Compatibility Mode.
6. You state that you don't believe that macros are running, but have you actually checked the Cisco files to verify that?
7. Have you checked for any Add-ins that may be installed in Excel?
8. You state that this happens "at random times," but have you verified that there is no commonality? Does it happen on different worksheets in the Cisco files? Does it happen when a specific operation is being executed?

As Glenn Ray stated in his post, the likely cause is either hardware- or software-related. This is true even though the symptoms described in the EE thread linked in his post aren't exactly the same as your users are experiencing. Differences in the symptoms may be due to different graphic cards, device drivers, or Service Packs.

I recommend following the steps suggested in that EE thread:

1. Check for updates to device drivers.
2. Verify that all Service Packs have been installed.
3. Check the graphics properties on the affected machines (status of hardware acceleration and refresh rate) and reset to default values for testing purposes.

I hope this helps.

- Blaise
0
 

Author Closing Comment

by:Awesome Itguys
ID: 40371687
I wanted to give it a few days to verify, but it seems a driver update, specifically the video worked. Thanks, all.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40371731
I'm saving this thread because of the very thorough and well-written post by Blaise.  Good methodology.
0
 
LVL 4

Expert Comment

by:C. Blaise Mitsutama
ID: 40371820
I'm glad that the OP was able to solve the problem and thanks to Glenn Ray for linking to the other EE thread.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

948 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

17 Experts available now in Live!

Get 1:1 Help Now