Exporting to Excel from MadgeTech 4 may raise this error for a number of reasons, as this feature relies on the functionality built into Excel itself. For this reason, Excel must be installed on the computer, and any cloud-based version of Excel is not compatible. If Excel is installed when the error occurs, please restart the computer to see if the issue persists. Otherwise, running the repair tool built into Microsoft Office may resolve the issue:
- Go to ‘Apps & Features’ in Windows and find the Microsoft Office entry
- Select the entry and choose Modify
- Select the Quick Repair option, then click Repair
- If Excel exporting still doesn’t work, also try Online Repair.
- For some computers, it may be necessary to completely uninstall and reinstall Excel.
- Save any open unfinished work and restart the computer when convenient.
If Excel is not installed, the repair tool does not resolve the issue, or the computer is using the cloud-based version, it is still possible to export the data to Excel.
With the data open in the MadgeTech 4 software, click ‘File → Save to → File‘ and select ‘Excel Files (*.xlsx)‘ in the ‘Save as type:‘ drop down box. Then save the file to the desired location on the computer. The drawback of this method is that it will not automatically create a graph.
The second workaround is to cut and paste the data directly into an open spreadsheet in Excel, or any other spreadsheet software. This requires a data table view of the dataset in the MadgeTech 4 software. If the graph report of the data open, simply click the Generate Data Table button in the Report toolbar. Another option is to right-click the desired dataset in the Files panel, and select Add to New Report → Data Table.
Once the data table has been generated, select a number of rows by clicking and dragging the left mouse button across the rows. If the goal is to select all of the data, click in the data table once and press CTRL-A to select all data. Once the desired data is selected, use the keyboard combination CTRL-C to copy the data to the clipboard. Finally, click on a cell in the spreadsheet software, and use CTRL-V to paste the data.