?
Solved

Excel lines turning black

Posted on 2013-01-28
12
Medium Priority
?
6,006 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 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
Technology Partners: 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 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

Evaluating UTMs? Here's what you need to know!

Evaluating a UTM appliance and vendor can prove to be an overwhelming exercise.  How can you make sure that you're getting the security that your organization needs without breaking the bank? Check out our UTM Buyer's Guide for more information on what you should be looking for!

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 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