+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Save excel workbooks in Technical; Since our upgrade to Win7 and Office 2010 we have encountered a problem with Excel, particularly in ICT lessons. The ...
  1. #1

    Join Date
    Jul 2012
    Location
    Northumberland
    Posts
    22
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    5

    Save excel workbooks

    Since our upgrade to Win7 and Office 2010 we have encountered a problem with Excel, particularly in ICT lessons. The security measures mean the students have to save their work differently when they work on Workbooks with new Macros. The work needs to be saved as "Excel Macro-Enabled Workbook" and to their share on the network seen globally as a "G" drive. Not a major problem as they can do that manually each time, problem is some forget and it is by default saved to local disk, then cleared on logoff.

    I know you can set these settings for individual users. We were thinking of a way to deploy to all users on the computers in that room the following changes to the "Save Options" in Excel;


    Excel save options.jpg

    Any ideas?

    Regards Dave

  2. #2
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Office 2010 GPO

  3. #3

    sonofsanta's Avatar
    Join Date
    Dec 2009
    Location
    Lincolnshire, UK
    Posts
    4,838
    Thank Post
    842
    Thanked 1,399 Times in 962 Posts
    Blog Entries
    47
    Rep Power
    603
    Quote Originally Posted by apeo View Post
    Office 2010 GPO
    Specifically User Config > Microsoft Excel > Excel Options > Save > Default file format = Excel macro enabled etc.
    Default file location is in the same folder, set that to G:\

  4. #4

    Join Date
    Jul 2012
    Location
    Northumberland
    Posts
    22
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    5
    Thanks guys worked a treat.

SHARE:
+ Post New Thread

Similar Threads

  1. Problems Saving Macro Enable Excel Workbooks on a Network
    By Richard_Finnigan in forum Office Software
    Replies: 2
    Last Post: 20th February 2012, 05:04 PM
  2. [MS Office - 2007] Excel refuses to save file after encrypting
    By TheCrust in forum Office Software
    Replies: 3
    Last Post: 20th November 2010, 10:01 AM
  3. [MS Office - 2007] Excel 2007 protect workbook asking for Information Rights Management Service
    By DSapseid in forum Office Software
    Replies: 2
    Last Post: 12th November 2009, 01:19 PM
  4. VB Script - saving an excel file?
    By Rawns in forum Coding
    Replies: 11
    Last Post: 17th July 2009, 10:44 AM
  5. Excel not saving/Networking
    By educateer in forum Mac
    Replies: 10
    Last Post: 24th September 2008, 10:54 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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