This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a workbook with tables that have the syntax "Month Name" + "Day".
I tried to create a table today with the Table Name "May2", and received the following error:
The name follows all of the rules listed above and does not conflict with an existing name in the workbook. I have tested all other combinations of "Month Name" + "Days" and am only receiving this error for the month of May.
This error returns for any combination of "May" + 1-6 numbers. For example:
May1
May12
May123
May1234
May12345
May123456
If there are 7+ numbers, this error does not appear. This occurs when I test this on excel on my personal computer as well as excel on my work computer.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
This is because MAY1, MAY12 etc. are valid cell addresses.
Try inserting an underscore, e.g. May_1 (or I'd prefer May_01)