Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing Formulas in Formula Bar (Excel 2000 SP2)

    When I click in any cell in a worksheet the formula does not appear in the formula bar, but there is a formula in the cell! Is there a setting somewhere that is set? There is no VBA code behind this as it happens on all workbooks regardless.

    All help much appreciated.

    Regards

    John

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Missing Formulas in Formula Bar (Excel 2000 SP2)

    A range can have it's protection status set to hidden, so that when the worksheet is protected the contents of cells do not show in the formula bar. However if the worksheet is not currently protected that would not apply. Try Tools, Protection and see if you can unprotect the sheet.

    You can switch of the hidden status by going to Format, Cells and on the Protection tab uncheck Hidden.

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing Formulas in Formula Bar (Excel 2000 SP2)

    Hi Andrew,

    Thank you for your reply. The sheets are not protected. If I click on a cell with either a number or text the value does not appear in the formula bar the only way to edit is to double click or F2 in the cell, however if I click on a cell with a formula in it the formula does appear in the formula bar and I can edit this.

    Regards

    John

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing Formulas in Formula Bar (Excel 2000 SP2)

    Is the formula bar displayed? If so, does anything display in it when you select a cell?
    Legare Coleman

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Glasgow, Scotland
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing Formulas in Formula Bar (Excel 2000 SP2)

    Hi yes the formula bar is showing, if I click in any cell that has either numeric or alpha characters the cell contents do not display in the formula bar, however if I click in a cell that has a formula the formula does.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing Formulas in Formula Bar (Excel 2000 SP2)

    I'm afraid I don't have a lot of ideas. A couple of things to check:

    1- Change your desktop color scheme in the control panel to see if maybe it is somehow displaying the contents in the same color as the background.

    2- Scan your system for virus with an up-to-date scanner.

    Can you upload a small workbook that displays this behavior on your system so we can see if it does the same thing on our systems?
    Legare Coleman

Posting Permissions

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