Save excel workbooks

[dksniper]

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;

 

 

 

Any ideas?

 

Regards Dave

[apeo]

Office 2010 GPO

[sonofsanta]

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:\

[dksniper]

Thanks guys worked a treat.