+ Reply to Thread
Results 1 to 3 of 3

Black cells, need refresh

  1. #1
    Registered User
    Join Date
    09-26-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    2

    Black cells, need refresh

    Hello everyone,
    I try to calculate a structure tension. It looks like a normal table, just a buch of parameters that are calculated as a function of an input. Well, when I enter that number and press enter those cells become black, and stay black till I "refresh" them. This is, scroll down till they're out of the screen and then scroll up again. Then I they're shown normally.
    I thought it was a RAM or video card issue, but I tried it in three computers and it happens in all of them.

    Does anybody know what is happening?
    thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,268

    Re: Black cells, need refresh

    Hi ellfalsote and welcocme to the forum,

    When you say "Cells Become Black" is not quite enough information to solve your problem.

    Do you have any Conditional formatting set in your workbook?
    Is the background black or are there just a bunch of ####### signs?
    What shows in the formula bar for a black cell?

    If you could post a sample of this problem in would much easier for us to solve it. Click on "Go Advanced" and then on the Paper Clip Icon to attach a file.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    09-26-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Black cells, need refresh

    Thanks for the reply.
    I mean literally black.
    I´ve attached the file. Type 2 in C3 and press enter.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1