Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Going Black

Posted on 2014-10-03
7
Medium Priority
?
404 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
[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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 27

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 1000 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 5

Accepted Solution

by:
C. Blaise Mitsutama earned 1000 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 5

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

715 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