When working with Excel-connections, it is important to be aware of the file structure and file-path. If the source-file is moved, renamed or unable to be located, you will get an error message in Grunt.
If you encounter the error-message "Workbook not found" in the Connections-tab of Grunt when updating data or checking the connection, Grunt is not able to find the source of the data where it originally was located.
To solve this, reconnect to the original file where it may have been moved by clicking on "file options", or the folder-icon to the right of the file path in the latter example.