Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgrades (2002/2003)

    Hello,

    I have documents that were originally created in Excel 2002. People who access these documents are on versions 2002 and 2003. The issue is that within the documents I have check boxes and those who open it in 2003 do not have the checkboxes or the graphics when opened.

    Do you know what causes this or how it can be corrected? Thanks for your help. I would like to attach word documents that show the differences but when I zip it, I can't get it below the 100K.

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

    Re: Upgrades (2002/2003)

    Maybe the 2003 machines have MAcro security set to high?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrades (2002/2003)

    I just checked and the security level is set to low.

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

    Re: Upgrades (2002/2003)

    First of all, I find it very unwise to have security set to low. Very.

    To your problem. Check TOols, options, view. WHat does it say for Objects (it should say "Show All")?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrades (2002/2003)

    I just checked this and it says show all is selected.

    I am going to attach screenshots of the document opened in the 2002 version. This will have to be done in two parts.

  6. #6
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrades (2002/2003)

    Here is the second page which shows the checkboxes.

  7. #7
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrades (2002/2003)

    Now, here are the screen shots showing the same document opened in version 2003. This will have to be done in 3 parts. This screen shot is a picture of the error message received when opening the document in 2003.

  8. #8
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrades (2002/2003)

    This is the screen shot showing that our company logo is no longer visible. I had to zip this because the file was too large.

  9. #9
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Upgrades (2002/2003)

    This is the shot that shows that the checkboxes are gone as well as the arrows that were drawn. This file is also zipped.

    Thanks for your help.

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

    Re: Upgrades (2002/2003)

    Sounds as if either the file or the controls have acquired some corruption. Follow these steps on the machine that opens the file successfully (the Excel XP machine I assume):

    - Go to the temp folder (start, run, type %temp% and click OK) and remove all files from that folder
    - Now start Excel and open the offending file (of which you first created a back up copy of course <img src=/S/smile.gif border=0 alt=smile width=15 height=15>)
    - File, save as. On the bottom of that dialog, change the file type to web page. Hit Save.
    - Close the file and Excel.
    - Open Excel, open the html file you just made (it should be # 1 in the recently opened file list in the file menu)
    - File, save-as and this time select "Microsoft Excel Workbook" as the filetype (=default).

    Now try this file on the Excel 2003 machines.
    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
  •