![]() To change this setting for ALL workbooks, you have to open Excel as if to create a new excel workbook, go to File > Options > Trust Center > Trust Center Settings > File Block Settings. NOTE: Going through this link only changes this workbook. As a result, you wont see the Security Warning again when you open this specific Excel file in the future. Note: by clicking Enable Content, the Excel file becomes a trusted document. When the message bar appears, click Enable Content to enable macros. In there, I unchecked the Excel 4 Worksheets (and workbooks for good measure) and now those files that we export from this particular app are opened in "editable" mode. To create macros, turn on the Developer tab. Click on the Protected View in the left pane of Trust Center window. Click on Trust Center Settings in the right pane. Under Options select Trust Center in the left pane. Click on Office or File button, and select Options. It then gives a link to "File Block Settings" which you've pointed out. Open any Office 2010 application (Ex: Word or Excel). "Editing this file type (Excel 4 Worksheets) is not allowed due to your policy settings" Click for more details." It specifically states what's doing the blocking: I notice that "Protected View" is the feature that's doing the blocking, but upon clicking the link "Editing this file type is not allowed due to your We have an application that exports XLS files in an old Excel version (much like Jason's AS/400 does). An alternative to adding the key, might be to go to the File Block Setting in the Trust Center, and un-check any old file types that may be checked off.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |