Allow brackets in filename or path
When a person's display name contains a bracket character (such as a departmental suffix) this bracket is included in the folder name of a OneDrive shared folder. When a recipient of that OneDrive shared folder attempts to modify an Excel spreadsheet and save it back to the shared folder, they will see an error that the file could not be saved due to invalid characters in the filename or path. If Excel could support the bracket character in the filename or path this would no longer be an issue. (An alternative solution would be to allow admins an option to have OneDrive shared folders use the owner's UPN rather than their display name.)
Lee Van Aalsburg commented
Thank you for the comment about brackets being problematic. Agreed with what you said, and was hoping that if brackets in the filename or path couldn't be implemented, then as an alternate option OneDrive could be updated to allow admins some control over the syntax used for shared folder names. (Such as using a person's UPN rather than their display name.)
Excel uses brackets in linking formulas to delimit the file name, and so brackets in filenames or paths are problematic. Unfortunately, there are no characters that are not allowed in paths or filenames that aren't already valid Excel characters for functions (e.g. > < ,), so there is no clear choice for changing the delimiters.
This would be most helpful. Thank you for implementing this