Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Quirks (Excel 2002)

    I know there are little fun things in Excel that the programmers built in. Example: When you type a certain phrase or word in a certain cell Excel will put something completely different in the cell, like a sentence or something. I have a slight problem. I have a spreadsheet that has a date column in it. This spreadsheet was built in Excel 97. When it was opened in Excel 2002, the first 10 cells in the date column changed. Instead of the date being there, there is now a little poem. It goes like this:
    Some people don't know how good it is just to see them.
    Some people don't know how comforting their smile is.
    Some people don't know how good it feels to be near them.
    Some people don't know how much poorer we would be without them.
    Some people don't know that they are like Heaven's gift to us.
    They would know if we told them.
    Like I'm Telling You.

    It was 1 line per cell. If anyone has an answer as to why this did this I would appreciate anything you have to offer. Thank you,
    Rick

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Quirks (Excel 2002)

    Sounds like whoever built the book has had a little fun at your expense. Have you tried erasing the contents of the cell?

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

    Re: Excel Quirks (Excel 2002)

    I don't know of anything in Excel that would do this. It sounds more like something a virus would do. Does the system have a good up-to-date anti-virus on it?
    Legare Coleman

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

    Re: Excel Quirks (Excel 2002)

    I have never heard of this, and there is nothing in the Excel newsgroups about this. Have you checked if the workbook contains macros? In particular, look for an Auto_Open macro in a standard module or a Workbook_Open macro in ThisWorkbook.

    BTW: previous versions of Excel contained an "easter egg", a surprise that could only be seen by entering some data in a specific location, but after complaints about the resources this took up, Microsoft apparently decided not to put an "easter egg" in Excel 2002. See Excel Oddities: Easter Eggs.

  5. #5
    New Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Quirks (Excel 2002)

    Hi Michael,
    Thank you for replying to my message. I was thinking the same thing, in fact, the person that works with this file the most moved on to another position in the company that very week. I think he must have decided to play with our minds a little. Again, thank you.
    Rick

  6. #6
    New Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Quirks (Excel 2002)

    Hi,
    Thanks for replying to my post. I have checked the file for virus's and found none. I thought in the beguinning that it may be a virus. I am now thinking that someone has played with our minds a bit. Again, thank you,
    Rick

  7. #7
    New Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Quirks (Excel 2002)

    Hi HansV,
    Thank you for replying to my post. I thought it very strange that Excel would do something like this, but I also thought that it might be possible. I had heard of the "Easter Eggs", in fact that was what I was referring to in my original post. I believe that the person that worked with this file the most has a lot to do with it. I think he must have inserted these lines of text simply to play with our minds. Again, thank you,
    Rick

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel Quirks (Excel 2002)

    Excel's Easter Egg(s) are buried in the application, not the workbook files it creates. For a definitive guide to Easter eggs, see http://www.eeggs.com/ If you would like to censor the workbook file and then post it here, someone can take a look at it and see how the trick was done.
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel Quirks (Excel 2002)

    Many years ago we had a high school student as a summer intern. He thought he'd teach himself to make macros. So he recorded a macro. He just did a little stream-of-consciousness typing, ended the recording and assigned it the "Ctrl-J" keystroke. Unfortunately, the macro was stored to the server shared area.

    So one day I get an irate call from the President's secretary. "Someone is out to get me! And it's not funny! Who is doing this?"

    Apparently, she accidentally typed Ctrl-J instead of Shift-J while typing and suddenly, the following text appeared in her document:

    "You are a dipsh*t. Stupid stupid stupid. La la la."

    That took a little investigating to figure out and a lot of apologizing to the poor woman who thought someone was sending text directly to her PC.

    Anyhoo, your example seems like it might be the same sort of thing. Especially since it's on multiple lines (not just a hijacked date function). Someone at some time may have created a little test macro and it accidentally got executed. If you have a irate president's secretary yelling at you it might warrant doing a Windows Explorer search of files containing a phrase of that text to find the source. Maybe someone really loves adding it to their spreadsheets with a quick shortcut keystroke.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  10. #10
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Quirks (Excel 2002)

    Did you ever have any luck getting into the VBE and checking to see if there is a Workbook_Open macro or another macro that puts the poem into the cells? Could even be a Sheet_Activate event. Just curious.

Posting Permissions

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