ITメモ

ITのこと学習中

Excel app is must for Business Central admin

In editing Excel file from Configuration Package, Excel is necessary. Other office application like Google Spreadsheet,  LibreOffice Calc, or else cannot edit the file. Cannot edit was too much. Those apps can edit, but not enough for the exported file.

LibreOffice can edit the exported file.

After editing the file, other office apps, Google Spreadsheet, LibreOffice Calc, or etc., delete XML map from the Excel workbook.  Excel for Web cannot even open the exported files from Configration Package. 

1) LibreOffice (v7.4)

Config. Package Data in LibreOffice

Config. Package Data in LibreOffice

The file can be imported into Business Central.

The file can be imported but...

Error: The Excel workbook must contain an XML map.

The Excel workbook must contain an XML map.

2) Google Spreadsheet

Google Spreadsheet can also edit the file, but saves it as .xlsm format. So Configuration Package rejects the file because of the extension is wrong.

Edit in Google Spreadsheet

Google Spreadsheet

Error: Unsupported file extension (.xlsm)

Error: Unsupported file extension (.xlsm)

What if change the file extension from .xlsm to .xlsx?  

The same error as LibreOffice comes out.


 

In order to edit Configration Package file, at least one Excel app is necessary.

If you believe Google Spreadsheet is enough, get good support from a solution partner for Business Central.