Overview
When attempting to save an excel document to the SmartVault Drive, you may find the file did not save, though you did not get an error message.
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.
Microsoft Excel is not capable of handling paths from internet locations over 180 characters.
A path is defined as the drive, all folders, and the files plus extension the system uses the organize your files. If this path is over 180 characters, then you will not be able to save the file.
For example, S:\My Account\My Folder\MyFile.xlsx is an example of a short path that is only 35 characters.
Resolving This Error
You can not change this behavior in Excel, so all you can do is to shorten folder or file names to get under this limit.
We recommend shortening higher-level folders as this will alleviate this issue for all lower-level folders. We also recommend not using very long filenames as you are more likely to hit your character limit regardless of folder size.
There are other error messages associated with this issue, and the resolution is the same: Excel errors when opening files.