When I export a set of albums to Excel and then open the resulting shortcut on my desktop, I always get this:
What version of Excel are you using James ?
Microsoft Excel 2016 MSO (16.0.9029.2106) 32-bit.
Just say Yes. I get the message but the file is still good for me. This issue is from an Office Security update that blocked XLS files with HTML code in them form “untrusted” sources. It used to be that the file would not open at all, then about a year ago they made the update to allow the file to open with a warning message.
Quoted from MSDN
The Excel team has released a change in HTML/XLS file behavior in today’s security update for Excel 2010, 2013, and 2016. Excel will warn about the mismatch between the file extension and HTML content, but will now open the workbook in Protected View as an additional layer of security.
2 Likes