One of our client sent me an Excel 2007 attachment file in Outlook but when I tried to open the attachment it says "Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
I have verified that the file type .xlsx is assigned to MS Excel 2007.
The client is sending this attachment from Excel 2007 > clicking Mail Recipient (for Review) icon (or better known as Send for Review in Excel command options).
The client also tried to send me the same excel file as a regular attachment (In Outlook, clicked new Mail, click Attach file OR from Excel by clicking the Office button, Send to Email). And I'm able to open those attachments.
Our Outlook 2007 is tied with Exchange 2003.
Do we need to have sharepoint so that I will be able to open the attachment?
I believe that the issue here would be the XLSX format. We also have issues in our office with emailed files that come in as HTML. Basically an XLSX file extension is an XML Format Spreadsheet file.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…