Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Posts
    142
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell contents not updating (2000)

    Once in a while, when using DIM or TODAY or some other macro, the cell doesn't update. For example, the macro =MID(Entry_Sheet!C15,1,50) works, but when I'm in the cell and want to change the length to say 55, after making the change, the cell shows the formula, not the results. After a little bit of fooling around, I eventually get the cell to display the correct data. This doesn't happen all of the time to the same cell: the ENTRY_SHEET has up to 20 of these and some work, some are inconsistant.
    Thanks in advance for your time.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell contents not updating (2000)

    This can occur if the cells are formatted as text. Try the following:
    - Select the cell or cells.
    - Select Format | Cells...
    - If necessary, activate the Number tab.
    - Select General (or, if you have date formulas, Date).
    - Click OK.

Posting Permissions

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