Solved

office 2010 issue

Posted on 2014-04-11
2
269 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel VBA 4 27
Excel Cell Total 3 21
Excel Drop Down List 13 34
How best to represent data in Excel? 13 27
If your app took Google’s lash recently, here are the 5 most likely reasons.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

810 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