Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel lines turning black

Posted on 2013-01-28
12
Medium Priority
?
5,579 Views
Last Modified: 2013-02-28
I've got an issue with some excel files. When i work in a workbook some of the lines turn black.

I don't use conditional formatting in this workbook.
The file is created in office 2007
I'm working with excel 2007
Windows 7 64 bit with office 2007 32 bit

Not only the cells turn black but also the line numbers.

When i select a black cell, and i start scroling, the text in this colom reappears. as you can see in the two screenshots i've attached.

Does anyone have a suggestion for this problem?
1.jpg
2.jpg
0
Comment
Question by:Hoenderdos
[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
  • 4
  • 4
  • 3
  • +1
12 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 38826693
can you post the workbook ?
gowflow
0
 
LVL 1

Expert Comment

by:ggoodwill
ID: 38826705
As above, the workbook would be helpful if the data isn't sensitive.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 38826728
is your file extention .xls or .xlsx ??? if .xls try converting it to .xlsx (save as and choose Excell 2007 workbook)
gowflow
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Author Comment

by:Hoenderdos
ID: 38826883
I'll ask the supervisor if the file may be published with or without current data.
when i recieved a confirmation i will post it here. in the meanwhile i'll try to save is as xlsx.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 38826992
ok fine
gowflow
0
 
LVL 1

Expert Comment

by:ggoodwill
ID: 38827093
Are we correct in assuming you're only having this issue with the one file? Does this problem appear on other PCs? If not then it might just be worth re-installing office.

The other thing I'd tried if it is just the document is copying the entire contents of the workbook, into a new workbook and saving it as a seperate file. This has fixed many quirks within documents for us here.
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38828549
Hello,

this is a rendering issue. Make sure you have the latest version of your graphics card driver and all Office and Windows Service Packs installed. It might also be a good idea to ramp up the machine's RAM.

cheers, teylyn
0
 
LVL 1

Author Comment

by:Hoenderdos
ID: 38828616
Thanks Teylyn,

I will try this suggestion also. The ram must be sufficient. its 4GB and there are no other processes. but the videocart driver isn't checked yet. I will do this as soon as possible.

The problem is on multiple documents. But is not always occuring. copying and pasting is not replicating the issue.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 38828686
if it is on mucltiple documents then you may want to check you refresh rate of the video card always set it to the default or else you may hv weired behaviour.
gowflow
0
 
LVL 1

Expert Comment

by:ggoodwill
ID: 38830226
I've had hardware acceleration cause similar issues also - it may be worth disabling / enabling this in your graphics card properties and seeing if this makes a difference, although if copying and pasting the contents doesn't replicate the issue, it point to a problem within the documents to me and it may just be worth doing this to all affected documents?
0
 
LVL 1

Author Comment

by:Hoenderdos
ID: 38850390
Thank you all for your suggestions. The problem occurs on a particular workstation and user. this user isn't available for further testing at this moment. As i am not on the same working site of this user i can't test your suggestions. please give me a week more time to test your suggestions.
0
 
LVL 1

Author Closing Comment

by:Hoenderdos
ID: 38937183
i've changed the driver of the graphics card. since then the problem didn't reocur.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

610 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