Solved

office 2010 issue

Posted on 2014-04-11
2
265 Views
Last Modified: 2014-06-30
when we try to open a shared excel or word document we receive this error:
the file you are trying to open, is in a different format than the specified by the file extension. verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

what is the best practice to find out why these files are not opening correctly.
0
Comment
Question by:CocoCounty
2 Comments
 
LVL 10

Assisted Solution

by:Scott Thomson
Scott Thomson earned 250 total points
ID: 39995470
Hello Coco

I am guessing you have just upgraded to office 2010?
If I am correct let me tell you why you are now getting this error.

This is a new security feature from Microsoft that verifies files on a code level to make sure that it adheres to a Microsoft format. The issue however is it does not work with 97-2003 versions of the file format.

http://support.microsoft.com/kb/2501584

If you upgrade your old excel files to a newer version this should stop the errors. but it is by design.
0
 
LVL 13

Accepted Solution

by:
Stacy Brown earned 250 total points
ID: 40035457
You can try changing some of your File Blocking options.

Go to File > Options  > Trust Center
Click the Trust Center Settings Button
Select File Block Settings
Uncheck the boxes for the file types you are experiencing trouble with
OK
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now