Tally.ERP9 provides an option to export its document or report to the formats like ASCII, ,XML,HTML Excel, PDF, JPEG etc. From MS Office 2007 onwards, the excel file default extension becomes .xlsx whereas Tally.ERP9 generates exported file as .xls. Many users use the default settings while exporting to excel and the excel file gets opened with a warning dialog box with a message of incompatible format. One option is to click on YES button. The alternate solution to edit the filename extension from .xls to .xlsx on Export settings form.
This is required only for MS Office 2007 or later
This editing can be done as follows:
This is required only for MS Office 2007 or later
This editing can be done as follows:
- A conformation dialog box appears when you click on Export button
- Make sure the format select is EXCEL
- Press BACKSPACE and change the file extension from .xls to .xlsx
- Open Exported File option must be YES
- Accept the settings (CTRL + A)
- Click on YES or press Y
The file will get opened without any warning