Results 1 to 11 of 11
  1. #1
    Lounger
    Join Date
    Jul 2002
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Set all Office 2010 apps to save to old formats?

    (Is it possible to set a new 2010 installation to NOT save to XML by default, in all apps, at one stroke, without using GP or the enterprise-only features.

    Say it's three Home/Student installs on a peer network, and some of the computers are XP home or xx Basic (no GP).)

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    20,374
    Thanks
    1
    Thanked 594 Times in 531 Posts
    You could construct a .reg file by examining the Office 2010 Group Policy Reference and extracting the appropriate registry keys.

    Joe

  4. #3
    Lounger
    Join Date
    Jul 2002
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I could, couldn't I, if I could *read* that humongous xls without migraine. I guess I could find each key with "format" in it, and verify that it's the save-in-x-format key for each app, if there's just one, write it out in ASCII/UTF-8, and hand-build a regfile. That kind of thing? MEGO.

    But thanks.

  5. #4
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    20,374
    Thanks
    1
    Thanked 594 Times in 531 Posts
    Does that mean you want someone else to do it for you?

    Joe

  6. #5
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    111
    Thanks
    11
    Thanked 6 Times in 6 Posts
    Perhaps you could address this problem with Word and Excel add-ins that manage the Save and SaveAs functions. Some hits from "excel addin saveas' looked promising to start the process.
    PJ in FL

  7. #6
    Lounger
    Join Date
    Jul 2002
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, guys, but after extracting a few keys and roughing out the differences among XPH, VistaB, etc., It's much, much easier to leave the policy changes to versions that have policy changes enabled, and slog through the interface for the others.

    And mock me if you will, but it's still hard to extract strings from huge keys that do not display fully (or even wrap properly) on any monitor known to mortal man.

  8. #7
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Quote Originally Posted by fhaber View Post
    (Is it possible to set a new 2010 installation to NOT save to XML by default, in all apps, at one stroke, without using GP or the enterprise-only features.

    Say it's three Home/Student installs on a peer network, and some of the computers are XP home or xx Basic (no GP).)
    I might be missing something here.
    Do you want to save Excel files as *.xls and Word files as *.doc?
    If so, there are only 3 systems, go to File>Options>Save in each of Excel/Word and change the default Save format.

  9. #8
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    111
    Thanks
    11
    Thanked 6 Times in 6 Posts
    Put this macro in the Personal.XLS (or Personal.XLSB) files of each computer and set the desired default save format accordingly.
    Code:
    Sub Auto_Open()
    '
    ' SetDefaultSave Macro
    '
    Const XLFILEFORMAT As Long = 56         '.XLS
    Const XL2007FILEMACRO As Long = 52      '.XLSM
    Const XL2007FILEBINARY As Long = 50     '.XLSB
    Const XL2007FILENOMACRO As Long = 51    '.XLSX
    
    ' Set the default file save format from the constants above for Excel 2007 or later.
    ' Do not use built in constants as Excel 2003 doesn't recognize pre-defined 2007+ constants.
    
        If Val(Application.Version) > 11 Then
    
    '###################################################################################
    '  Only the THEN leg can be modified!
    '  Do not change the default in the ELSE leg!
            Application.DefaultSaveFormat = XL2007FILEBINARY
    '###################################################################################
        
        
        Else
    
    '###################################################################################
    '   Do NOT change this line!
            Application.DefaultSaveFormat = XLFILEFORMAT
    '###################################################################################
        
        
        End If
    
    End Sub
    The same type of macro can be built for Word and put into the Default.Dot template file.
    PJ in FL

  10. #9
    New Lounger
    Join Date
    Dec 2009
    Location
    Fort Wayne, Indiana, USA
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I found that the How-To Geek has instructions for setting Office 2007 to save in Office 2003 format. The problem is that you have to change Word, Excel and PowerPoint separately and you have to change each computer. It was easy to do and they have picture tutorial.

    http://www.howtogeek.com/howto/micro...d-2003-format/

  11. #10
    New Lounger
    Join Date
    May 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Nice thread, good information.

  12. #11
    New Lounger
    Join Date
    Jul 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Set OFFICE 2010 default format (xls, dox, ppt)

    Hey

    Go into the oct and add these reg keys

    regkeysoffice2010.jpg

    This adds the keys while installing
    If you have already installed then just add these regkeys via the gpo


    [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\P owerPoint\Options]
    "DefaultFormat"=dword:00000000

    [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\W ord\Options]
    "DefaultFormat"="Doc"


    [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\E xcel\Options]
    "DefaultFormat"=dword:00000038

    Cheers

Posting Permissions

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