Results 1 to 11 of 11
  1. #1
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Red Asterisk (2000 9.0.6926 SP-3)

    Today I noticed a red asterisk in the upper left corner of a recently entered cell.

    When I attempt to add the contents of the cell to the contents of a second, I got the error message "#Value", suggesting that the red asterisk is significant.

    What did I do wrong?

    Thanks,

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  2. #2
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    Since nobody jumped on this with a quick explanation, I tried an experiment. I put a 10 pt asterisk into a neighboring cell, and did a screen dump to Word. With the offending cell 'selected' (a dark black band around the cell) the red 'asterisk' became a downward pointing red arrow. I 'formatted the picture' and trimmed it to just a few cells, dragged it and 'zoomed' to 500%. The outlines of both characters are 'fuzzy' with the black asterisk I inserted being a square about 2/3 the maximum dimensions of the red arrow. I screen dumped an image of that to a second Word document. I've attached a copy of that Word file.

    Baumgrenze

    Does this tell anybody anything more?

    Thanks,

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

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

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    Posting a stripped down version of the workbook would be more helpful.

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

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    That's kind of like me posting a picture of my car and asking you to tell my why it won't start. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Any chance you could delete every thing from the workbook but that one cell and then post a copy of the workbook?
    Legare Coleman

  5. #5
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    Thank you Hans and Legare,

    As per your request, here is a copy, without data. The cells are A1 (contains the entered copy of a 10 pt Arial asterisk) and A2 (contains the mystery 'down arrow in red.'

    For what it is worth, the worksheet I copied had rows 1-79 at least partially occupied and columns A - AC partially occupied. The above cells were originally at Y42 and Y43.

    I used <edit-delete> to move the cells to the 'home' position and then deleted the contents of the remaining cells which still had data in them.

    Thanks,

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  6. #6
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    The red arrow is an object, in this case a picture, that has been added to the workbook. If you do not want it then you can delete it by clicking on it to select it and pressing delete. When it is selected you will see small circles around it.

    The example file you posted contains a lot of objects (pictures) in cell A1, you can select them all by selecting Edit>Goto (or press Control+G), click Special and then select the Objects option and click OK.

  7. #7
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    Thanks Tony,

    I may have inadvertantly copied an object from a web site. The original data were copied and pasted from a Fidelity.com account page. I've never seen the object in question on the website, however.

    I just zoomed that sheet to 200%. All I see in A1 is the 10 pt asterisk I put there. All I see in A2 is the red down arrow.

    I am troubled that you say that there are a lot of objects. On reflection, I've had experience with objects before. The cleanup process I used to create this workbook would have pushed a bunch of crap into A1 because selecting a range of rows and columns and invoking <edit-delete> does not delete objects.

    What else do you see?

    Thanks,

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  8. #8
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    The objects in cell A1 are a load of blank pictures placed on top of each other. As you surmised this is probably due to the rows & columns being deleted, and they were probably placed throughout the sheet prior to this.

  9. #9
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    Thanks Tony,

    What triggered this whole question was a "#Value" error message when I try to add two numbers, one of which is in the cell in question in the original workbook. Would this situation trigger this error? Would Excel see both the object(s) and the number and decide that the action was inappropriate?

    Blank pictures are pretty hard to troubleshoot. How did you know they were there? Should I be able to see them with Excel 2000?

    Thanks,

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

  10. #10
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    Using your example file I do not get any errors when creating calculations that use the cell with the arrow in it.

    If you want to find any objects use the Goto dialog (Control-G), click Special and then choose Objects and finally click OK. You will be able to see the selected objects as they will now have small circles around the outside of the objects, these circles being the handles that you can use to manipulate the object. Experimenting with these objects showed there were multiple objects on top of each other in cell A1.

  11. #11
    3 Star Lounger baumgrenze's Avatar
    Join Date
    Feb 2001
    Location
    California, USA
    Posts
    262
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Red Asterisk (2000 9.0.6926 SP-3)

    Thank you everyone for the 'object lesson' on objects.

    I looked hard and found the source of my "#Value" error. It was a "space" before a $ in a value which I'd copied and pasted. The cell contents were slightly out of line. Once I eliminated the space the addition worked.

    And this is from a program that won't allow me to format a cell so that it can contain a fraction "1/2" without insisting that it is a date or a range of numbers "1-2" without doing the same.

    There's another thing that it very hard to see and the error message is about as helpful as not getting one at all.

    I guess that is job security for the crew in Redmond; there's always room for improvement in the next iteration.

    Baumgrenze
    Baumgrenze
    Hier sind wir tief eingewurzelt.

Posting Permissions

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