• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2158
  • Last Modified:

How to disable the annoying compatibility warnings in Excel?

Hi Experts,

Every time a user edits a CVS or 2003-2007 Excel file it gives a warning that it will be saved in compatibility mode.

The client has requested we disable the 'Compatibility mode pop-up', since all their users operate on 2010 any way

Is there any way to achieve this using office 2010 gpo's?
0
James Glen
Asked:
James Glen
  • 2
  • 2
1 Solution
 
Alex_WCommented:
0
 
Haresh NikumbhSr. Tech leadCommented:
you can do it with Office 2010 Administrative Template files (ADM, ADMX/ADML) and Office Customization Tool download

http://www.microsoft.com/en-us/download/confirmation.aspx?id=18968

after import you need to find out setting name

Suppress file format compatibility dialog box for OpenDocument Spreadsheet format which
Allows you to enable use of the file format compatibility warning, or to disable it from appearing when users save a file as an OpenDocument spreadsheet (*.ods) file in Excel.
0
 
James GlenIT EngineerAuthor Commented:
True i could force them to be saved as .xlsx, but they have a few macro enabled spread sheets. Wont that break them since they need to be saved as .xlsm?

I wasn't sure if that openDocument format suppression was applicable as the issue was with office 2007 documents?
0
 
Haresh NikumbhSr. Tech leadCommented:
That's true i am not sure if anybody has tested this in live Env. you can check it out creating this policy and apply it only for 1 machine and check it out result.
0
 
James GlenIT EngineerAuthor Commented:
It would appear that, that fixed it :) cheers takecoffe
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now