Excel hotsheets: Error: 'Excel cannot open the file because the file format or file extension is not valid'

When being presented with the error message 'Excel cannot open the file because the file format or file extension is not valid' when running excel hotsheets, this is down to macros being disabled within your company.
​
Contact your IT department who will then be able to enable these for the tool to run as expected.