Microsoft Office 2016: The Complete Guide (2015)

EXCEL CANNOT SAVE THE WORKBOOK BECAUSE IT DOESN’T HAVE ANY MAPPED RANGES.

Excel is unable to save the workbook because it is not equipped with mapped ranges. Excel is unable to save your workbook in the XML data files only if you create one more mapped range. In the event that you should add on XML map to your workbook, the following steps are essential for mapping XML elements to your worksheet:

On the Developer Tab, in the XML group, select Source

If the [Developer] tab is not visible see Show the Developer Tab link.

In the XML Source task pane, click one element, hold down CTRL, and then click each element.

Drag the selected elements to where you want them to be visible on the worksheet.

If you have not added an XML map to your workbook or if your data is not an XML table, save your workbook in the Excel Macro-Enabled Workbook file format.

Show the Developer Tab

Select file, and then click options.

Select the customize Ribbon category.

Underneath main tabs, select the Developer check box, and then click OK.