Issue
Get the following error when attempting to import histories into an Excel spreadsheet: "The specified XML source does not refer to a schema. Excel will create a schema based on the XML source data." when attempting to import the file into excel"
Environment
Niagara G3
Cause
The problem turns out to be a quirk in the Excel UI. There are two checkboxes on top of one another (due to there being no margin around the table); the one on top is for the entire page, the one underneath is for the table. Selecting the checkbox you can see only selects the entire page, which is the cause of the XML schema issue.
Resolution
To workaround this:
- Hit [tab] once and it should highlight the page checkbox in green
- Hit [tab] again to give focus to the table underneath
- Hit [enter] to check the checkbox for the table that cannot be seen
- Click [Import] and the data should import properly.