Bug
Business Analyst Desktop returns an error attempting to open an XLSX workbook generated in the Microsoft Excel 2016 (64-bit) application.
| Bug ID Number | BUG-000122261 |
|---|---|
| Submitted | May 8, 2019 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Business Analyst Desktop |
| Version found | 10.6 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Known Limit |
Additional Information
Duplicate of BUG-000096855. See link: http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm To resolve the issue, download and install Microsoft Access Database Engine 2010 Redistributable: https://www.microsoft.com/EN-US/DOWNLOAD/DETAILS.ASPX?ID=13255Workaround
The file can be saved in another format from Microsoft Excel, but this creates extra work for the users. A workbook can contain multiple pages, but the CSV substitute can only contain one single sheet.
Steps to Reproduce
Bug ID: BUG-000122261
Software:
- ArcGIS Business Analyst Desktop
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App