This behavior is based on a 256-character limitation in Excel for creating links to another file. This limit of 218 characters for the path name is based on the following:
- Up to 31 characters in a sheet name.
- Apostrophes and brackets used to denote the workbook name.
- An exclamation point.
- A cell reference.
Note This behavior will also occur if there is a square bracket in the path.
What To Try
- Rename the file so that it has a shorter name.
- Rename one or more folders that contain the file so that they have shorter names.
- Move the file to a folder with a shorter path name.
Save As dialog box, and click OK, you will receive the following error message:
- Make sure the specified folder exists.
- Make sure the folder that contains the file is not read-only.
- Make sure the file name does not contain any of the following characters: < > ? [ ] : | *.
- Make sure the file/path name doesn't contain more than 218 characters.