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 ...
11th October 2012, 09:48 AM #1
- Rep Power
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
11th October 2012, 10:41 AM #2
11th October 2012, 11:09 AM #3
Specifically User Config > Microsoft Excel > Excel Options > Save > Default file format = Excel macro enabled etc.
Originally Posted by apeo
Default file location is in the same folder, set that to G:\
11th October 2012, 12:05 PM #4
- Rep Power
Thanks guys worked a treat.
By Richard_Finnigan in forum Office Software
Last Post: 20th February 2012, 05:04 PM
By TheCrust in forum Office Software
Last Post: 20th November 2010, 10:01 AM
By DSapseid in forum Office Software
Last Post: 12th November 2009, 01:19 PM
Last Post: 17th July 2009, 10:44 AM
By educateer in forum Mac
Last Post: 24th September 2008, 10:54 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)