Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    2004/2005 (2000)

    Hi, one of my clients reports that when putting 2004 into a sheet it transfers in 2005. Other things go well. Like 2005 is 2005, and 2003 is 2003. Adding 1 to 2003 (=2003+1) makes 2004. Little weird, it happens on 2 pc's, one with the Dutch version and one with the English version. Both have SP3. Anyone familiar with this behavior?
    It doesn't happen with me, but I tested it on their pc's and found this happen.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: 2004/2005 (2000)

    I don't understand what you mean by "when putting 2004 into a sheet it transfers in 2005". Could you elaborate?

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: 2004/2005 (2000)

    The most simple way: open a worksheet, put 2004 in A1, push TAB or ENTER, and A1 says 2005.
    Couldn't believe what I saw. Can you?

    Sjors

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

    Re: 2004/2005 (2000)

    Follow the steps in Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post> on a problem PC.

  5. #5
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: 2004/2005 (2000)

    Hi Hans,
    Did all there is in the manual of Jan Karel. No luck.
    Best way to uninstall and reinstall?
    Also nothing in Excel Start dir.
    Maybe deleting personal.xls?
    BVD
    Sjors

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

    Re: 2004/2005 (2000)

    The first step in Jan Karel's troubleshooting guide is to start Excel with the /Automation switch. This loads Excel without loading Personal.xls etc. So if the problem still persisted, Personal.xls is not the culprit and there is no need to delete it.

    Try Help | Detect and Repair from within Excel - you may have to insert your MS Office CD.

  7. #7
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Middelburg, Zeeland, Netherlands
    Posts
    165
    Thanks
    20
    Thanked 2 Times in 2 Posts

    Re: 2004/2005 (2000)

    Ongelooflijk, this is what you're not gonna believe:
    user put 2004 in autocorrect!
    deleted that and everything worked like it should.
    Wotdoyoumean: usererror :-(
    tnx

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

    Re: 2004/2005 (2000)

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

Posting Permissions

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