+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Group Policy to force automatic calculations in Technical; Is there a group policy add-in to force automatic calculations in Excel? I'm on Office 2003, the setting is in ...
  1. #1
    Gibbo's Avatar
    Join Date
    Feb 2008
    Location
    Cheshire
    Posts
    919
    Thank Post
    210
    Thanked 346 Times in 239 Posts
    Rep Power
    93

    Group Policy to force automatic calculations

    Is there a group policy add-in to force automatic calculations in Excel?

    I'm on Office 2003, the setting is in TOOLS - OPTIONS - CALCULATIONS, but I can't see a Calculations folder in Group Policy.

    The option is set to automatic but there are a few Excel files on the network which have been set to manual and the staff don't want to have to make the change, they want it done automatically for them.

  2. #2

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,909
    Thank Post
    3,435
    Thanked 1,084 Times in 1,000 Posts
    Rep Power
    370
    Quote Originally Posted by Gibbo View Post
    Is there a group policy add-in to force automatic calculations in Excel?

    I'm on Office 2003, the setting is in TOOLS - OPTIONS - CALCULATIONS, but I can't see a Calculations folder in Group Policy.

    The option is set to automatic but there are a few Excel files on the network which have been set to manual and the staff don't want to have to make the change, they want it done automatically for them.
    You would have to get the office 2003 admin pack / adm templates
    and you should be able to use that to set whatever settings via group policy for office 2003

    http://www.microsoft.com/downloads/d...displaylang=en

    http://office.microsoft.com/en-us/or...513711033.aspx

    I just googled for office 2003 adm and it populates the drop down menu with certain options ie adm templates etc

    so am sure you could go from there - all documented

  3. #3
    Gibbo's Avatar
    Join Date
    Feb 2008
    Location
    Cheshire
    Posts
    919
    Thank Post
    210
    Thanked 346 Times in 239 Posts
    Rep Power
    93
    Yep, I've got and installed them, but there doesn't seem to be an option for the "TOOLS - OPTIONS - CALCULATION" tab

    Incidentally, where is the best place to install them? The MS document I read said it should be installed on the user's group policy, but in another it said the computer.

  4. #4

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,909
    Thank Post
    3,435
    Thanked 1,084 Times in 1,000 Posts
    Rep Power
    370
    Quote Originally Posted by Gibbo View Post
    Yep, I've got and installed them, but there doesn't seem to be an option for the "TOOLS - OPTIONS - CALCULATION" tab

    Incidentally, where is the best place to install them? The MS document I read said it should be installed on the user's group policy, but in another it said the computer.
    I would say users but will let someone else take over as not got access to the correct enviroment to play around with it - no read me or manual / instructions that came with the adm templates ?

SHARE:
+ Post New Thread

Similar Threads

  1. TS Group Policy
    By adamf in forum Windows
    Replies: 6
    Last Post: 4th May 2008, 12:35 PM
  2. Excel 2007 - Calculations
    By wesleyw in forum Windows
    Replies: 3
    Last Post: 14th January 2008, 01:22 PM
  3. group policy
    By kevin_lane in forum How do you do....it?
    Replies: 2
    Last Post: 27th July 2007, 12:17 PM
  4. Replies: 4
    Last Post: 12th July 2007, 08:11 PM
  5. Force Group Policy installation to run again
    By Craig_W in forum Windows
    Replies: 4
    Last Post: 28th November 2006, 11:38 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
  •