Other customers are reporting a similar problem.
It appears that Google released a bug on Jan 11, 2019 in the way it exports Google Sheets in Excel .xlsx format.
When Google exports a Google Sheet in Excel format, it creates a “workbook.xml” file containing the entire Google workbook. One section in the “workbook.xml” file contains a list of all of the Defined Names specified in any of the worksheets of the workbook. Excel expects every Defined Name to have a unique name value. Unfortunately, it appears that Google is exporting the Defined Names incorrectly. As a result duplicate names are appearing the section of the exported “workbook.xml” file.
You can verify this as follows:
Open the workbook in Google Sheet.
On the Google Sheets “File” menu select “Download as” and then “Microsoft Excel (.xlsx)”. This will export the Google workbook as an Excel document.
At the bottom left of the browser page you will see the exported .xlsx file.
Click the ^ and open the file in Excel.
Excel will report an error when it attempts to open the exported .xlsx file.
The .xlsx file is simply a compressed Zip file containing a folder made up of XML files that represent the workbook, each individual worksheets, and all other workbook related information.
You can examine the Excel file by: 1. Renaming the file extension from .xlsx to .zip 2. Right clicking the file and selecting Extract All. 3. Open the resulting folder and navigate to the “workbook.xml” file. 4. Open the “workbook.xml” file. 4. Look for the XML element and you will see duplicate values.
I am not certain what is causing these duplicate Defined Name values. I presume that the Google export problem depends on some feature being used in the failing workbooks, but I am not sure what the feature is. The only thing I can suggest is trying to make changes to your worksheet and see if that eliminates the problem.
If you figure out what is causing the duplicate name, please share it to help others.
You can test whether you have eliminated the problem by exporting the updated workbook and opening the resulting .xlsx file in Excel. Once Excel can open the exported file, AppSheet should be able to do so also.
The problem has been reported to Google. See
accounts.google.com - Sign in - Google Accounts
Sign in - Google Accounts accounts.google.com