Jun 06 2022 04:57 PM
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!
Jun 08 2022 02:51 PM
I can't reproduce that
Jun 09 2022 08:11 AM
@Sergei Baklan - 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.
Jun 09 2022 08:28 AM
Jun 09 2022 09:29 AM
Jun 09 2022 09:54 AM
@Bob_Posert As another data point I couldn't reproduce it either with my version:
so if you change the column name you have no problems?
Something else to try is to log into windows under a different account (just create a new local account) and try it again in that new account.
Jun 09 2022 10:24 AM
Sorry, have no idea. Do you have around computer with other than Enterprise Semi-Annual Channel installation to try?
Jun 09 2022 11:10 AM
Jun 09 2022 03:34 PM
Jun 09 2022 04:09 PM
Jun 09 2022 05:03 PM
Jun 10 2022 08:48 AM
Jun 15 2022 10:15 AM
Jun 15 2022 01:41 PM
Perhaps that was a bug in concrete build.