Why do I get a message saying the name of my report or sheet is not valid?
You may occasionally see a message saying that the name of your report or sheet is not valid.
This is a restriction imposed by Excel. When Openbox sends your model to Excel, every sheet and report gets turned into an Excel sheet. That means that the name must be a valid Excel sheet name. But Excel does not allow the following characters:
\, /, %, [, ], :, ?
You also can’t start or end a name with a single quote. So ‘do not’ is not allowed. But don’t is ok.
Names longer than 31 characters are not allowed.
Finally, one bit of trivia. You can’t name an Excel sheet History (try it for yourself). So, Openbox doesn’t let you do that either.