Solved

Excel lines turning black

Posted on 2013-01-28
12
2,150 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 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
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 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

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
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…

733 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