I'm having issues with a work colleague who is not able to open the attached excel spreadsheet. I am using Excel 2007 and he is using excel 2003. However, the file (which contains macros) is saved in 2003 compatibility format.
Yet even when I open it, I get a warning "The file you are trying to open "[File Name].xls" is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file?"
When I click yes, it opens fine. When my colleague opens it, it opens as jibberish/garble.