Forum Discussion
Bob_Posert
Jun 06, 2022Copper Contributor
Error in O365 Data Model when a column named "Moving"
I'm running into a strange problem saving data models, and would appreciate any help.
Perhaps there are reserved column names in Excel data models?
Here are steps to reproduce:
Version: Microsoft® Excel® for Microsoft 365 MSO (16.0.14326.20936) 64-bit
1. Enter data according to these steps:
1a. In cell A1, Moving
1b. In cell A2, 1
1c. In cell A3, 2
Your spreadsheet should look like this:
A | |
1 | Moving |
2 | 1 |
3 | 2 |
2. Click on Cell A1
3. Select Insert, PivotTable
4. In the popup, check Add this data to the Data Model, and leave other defaults (Range Sheet1!$A$1:$A$3, New Worksheet)
5. Click OK in the popup - you will see an empty pivot table
6. Click File->Save, select any filename (.xlsx format)
Expected behavior: The file saves
Actual behavior: Error message "Errors were detected while saving '(filename)'. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file click Continue. To cancel saving the file click Cancel."
This seems odd, but is easily reproducible with other data in rows 2+ (the column name seems to cause it), and I can't find anything online about it.
Thanks!
13 Replies
Sort By
I can't reproduce that
- Bob_PosertCopper Contributor
SergeiBaklan - another person at my organization is able to reproduce it. What version of Excel are you using? I wasn't able to reproduce on an older version.