Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Building wkshts for others. (Excel XP SR1)

    I know that the people who will use my excel files have various versions of Excel. Some have 97, a few have XP but the majority have Office 2000.

    It's important that everyone will be able to use the files. So, should I use Excel 97 when constructing the worksheets to guarantee compatibility?

    If the answer is "yes", then:

    Because I enjoy using XP and do not wish to uninstall, can 97 and XP live together on the same PC? <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    - Ricky

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Building wkshts for others. (Excel XP SR1)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Ricky

    YES YES YES!!! Use the lowest common denominator and develop on it to ensure compatability.

    Yes you can have Excel 97 and 2000 and 2002 all on the same machine. In all different folders no doubt. The only consideration is disk space.

    BUT install your favorite version last. This way File association will be preserved for that version.

    If you are not planing on using any of the features of the newer versions you can still work with 2002.

    But development should be always at the least common denominator . Unless you want to have multiple versions.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Building wkshts for others. (Excel XP SR1)

    %$#@!%, <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>I knew you'd say that!
    - Ricky

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Building wkshts for others. (Excel XP SR1)

    Ricky

    You can still use Excel 2002, but you should not use any of its features that are not supported in 97 and 2000. Very few, but you only need one to make it incompatable.

    Good luck...

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Building wkshts for others. (Excel XP SR1)

    Ricky, With a site having the same problem, I use the save as and then choose the version. In our case this is Excel 5 / 95. However I only use 2000, and do not believe that you need each version of Excel on your PC.
    Unless I have used macros commands or features not supported by earlier versions then I have experienced very few problems.
    In one case I have a complicated cost and material yield workbook which has six or so macros. Saved in v5, and the only tidying up to be done was the make the v5 module tabs invisible.

    <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>
    Paul Coyle
    Approach love and cooking with reckless abandon

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

    Re: Building wkshts for others. (Excel XP SR1)

    That only works partly. E.g. compile errors will only surface once the file is opened and used in the older version. Building it in the oldest version ensures one doesn't use properties or methods incompatible with older versions.

    One example: for XP, the Find method has more arguments than for the previous versions, possibly rendering a compile error when run on e.g. XL97 if all arguments have been used (which will happen when you recorded a macro doing the find!).
    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
  •