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 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.
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.
Resolving This Error
Modifying the security option under Protected view can fix this issue. However, you should be aware 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 may be safe, you also open the door to disabling this protection from files you open from other Internet resources.
- Open Excel.
- Click on File > Options.
- Select Trust Center > Trust center settings.
- Select Protected view.
- Disable the Enable Protected View for files originating from the Internet checkbox.
- Click OK.
- 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 file names to below 200 characters.