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.)
Please consider working on /fixing this [again].
I'm afraid I don't quite understand the choice not to allow brackets or other characters (allowed at file system level) in paths for *all* excel files.
I mean you could "simply" (you'll evaluate the actual level of difficulty) forbid the "linking" of a "bad formatted" file path in expressions but you should allow the "standard opening" of regular files. I mean, if I need to link a file it would be acceptable to ensure *that file only* to have a "nice" path because of a limitation in linking-formula syntax; why should I worry about *all the files I have* for that specific (not that often used IMHO) linking feature/need?
Thanks for listening/reading.
Mat Kay commented
Can confirm this is still an issue.
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