• 2004/2005 (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » 2004/2005 (2000)

    Author
    Topic
    Sjors van der Horst
    AskWoody Plus
    June 23, 2008 at 7:58 pm #451926

    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.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSsdckapr
      AskWoody Lounger
      June 23, 2008 at 9:15 pm #1114008

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

      Steve

      Reply | Quote
      • Sjors van der Horst
        AskWoody Plus
        June 23, 2008 at 9:42 pm #1114010

        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

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          June 23, 2008 at 10:34 pm #1114018

          Follow the steps in Jan Karel Pieterse’s Systematic Approach to Behavioral Problems in XL on a problem PC.

          Reply | Quote
          • Sjors van der Horst
            AskWoody Plus
            June 25, 2008 at 3:26 pm #1114328

            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

            Reply | Quote
            • WSHansV
              AskWoody Lounger
              June 25, 2008 at 3:39 pm #1114350

              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.

              Reply | Quote
            • Sjors van der Horst
              AskWoody Plus
              June 25, 2008 at 5:35 pm #1114370

              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

              Reply | Quote
            • WSHansV
              AskWoody Lounger
              June 25, 2008 at 5:37 pm #1114376

              hairout laugh

              Reply | Quote
    Viewing 0 reply threads
    Reply To: 2004/2005 (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.