Solved

Excel lines turning black

Posted on 2013-01-28
12
1,850 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
  • 4
  • 4
  • 3
  • +1
12 Comments
 
LVL 29

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 29

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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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 29

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 earned 500 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 29

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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

832 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