Customer Center
Help Topics
Self-Help Guides
Home > Support > Knowledge Base and Known Issues > Opening an Excel file generates errors

Opening an Excel file generates errors

Table of contents

Overview

When opening some MS Office 2010 files from the SmartVault drive, you sometimes receive one of these errors:

Error 1: A file is corrupt and cannot be opened.

Error 2: Excel cannot open the <file name="">because the file format or file extension is not valid. Verify the file is not corrupted and that the extension matches the format of the file.

 

The file may also open to a blank screen with no content. 

 

Cause

MS Office has Trust Center security settings for files originating from internet locations like the SmartVault Drive, and may open the file in Protected View mode. When the total path to the file exceeds 180 characters you will get one of these errors when opening the file. 

Resolution


Modifying the security option under protected view can fix this issue, however you should be aware that that disabling this setting does put the burden of security and protecting your computer on to the customer. Changing this security setting means that you are making an informed decision and are actively screening of the types of files you open from the Internet. Although, the files you open and save in SmartVault maybe safe, you also open the door to disabling this protection from files you open from other Internet resources.


1. Open Excel.
2. Click on File > Options. 
3. Select Trust Center > Trust center settings. 
4. Select Protected view. 
5.Uncheck “Enable Protected View for files originating from the Internet ” 
6. Hit OK 
7. Restart Excel and try to open Excel documents in the issue context. 


Note: Regardless of the above resolution there is still a maximum path length after which MS Office will not be able to open the file.  If the path is longer than 200 characters Office will generate one of the above errors. At this point all you could do is shorten your folder and/or file names to below 200 characters. 

 

You must to post a comment.
Last modified
13:20, 13 Aug 2014

Tags

Classifications

This page has no classifications.