Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Going Black

Posted on 2014-10-03
7
Medium Priority
?
411 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 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
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!

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 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