Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    File format: XP vs 2000 (XP/2000)

    Are there any issues with creating a workbook in 2000 or XP and using it in the other version? If so then when I create a workbook in XP is there a way to make sure it will work fully in 2000?

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

    Re: File format: XP vs 2000 (XP/2000)

    Excel workbooks created in XP are compatible with 2000 and 97. Files created in XP should work fully in 2000. That is the official Microsoft line and so far all workbooks I have shared between XP & 2000 work properly.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File format: XP vs 2000 (XP/2000)

    I guess as long as you stick to functionality that is NOT unique to XP, you should be OK. If you're going to write an application (VBA program) in XL, easiest is to build it in 2000 and test it in XP. This ensures you don't use VBA statements and methods that are new as of XL XP. An example: in XP, the OpenText method has more arguments then previous versions.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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