Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, June 14, 2016 3:31 PM
Why can Windows 7 Preview not show Macro Enabled, Office 10 Excel Workbooks (.xlsm)?
If the Macro Workbook is from a Trusted Source and the Excel settings are correctly set to open the workbook, why should it not be possible to provide a preview of the content of the workbook without running any associated macros?
In my case I have an externally called calculation workbook that accepts a data set, performs some calculations and is then saved as a record of a test completed. In the past, we have used .xlsx workbooks with in-cell formulas and have always been able to preview the files - saving a lot of time. Not being able to preview the .xlsm files is making things very difficult for us as we have to open the files in Excel just to check the final test result.
Is there really no simple solution to this?
Many thanks in advance for anyone's help!!
All replies (1)
Wednesday, June 15, 2016 8:30 AM âś…Answered
Hi Richard Slack,
Did you mean you cannot preview .xlsm files in Windows 7?
As far as I know, .xlsm file format is not support to be previewed in Windows 7.
I suggest you try to refer to this similar case and reply of Andreas, maybe this can be a work around for you:
>>
You can only get a "preview" when you saved a thumbnail before:
- Open an Excel file
- File\SaveAs and choose a (the same) location
- Check the "Save Thumbnail" check box
- Click Save
After that you can see the thumbnail within the Windows Explorer and/or in the Open dialog when change the view to Icons.
The only other way is to use an Excel viewer:
https://www.microsoft.com/en-us/download/details.aspx?id=10
<<
You can also refer to this article about how to add file types to Windows 7 preview pane:
http://www.howtogeek.com/forum/topic/add-file-types-to-windows-7-preview-pane
Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.
Important Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
Please refer to this article about how to back up and restore the registry in Windows:
https://support.microsoft.com/en-us/kb/322756
Hope it's helpful.
Regards,
Emi Zhang
TechNet Community Support
Please mark the reply as an answer if you find it is helpful.
If you have feedback for TechNet Support, contact [email protected].