Forum Discussion

Bob_Posert's avatar
Bob_Posert
Copper Contributor
Jun 06, 2022

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
1Moving
21
32

 

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!

Resources