从界面上导出的Excel无法打开，提示内存不足

Excel2016遇到了如上图所示的问题：

Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space.

To make more memory available, close workbooks or programs you no longer need.

To free disk space, delete files you no longer need from the disk you are saving to.

解决方法：

1. Open any new document in Excel, and click FILE -> Options.

2. Next, in the left pane of Excel Options window shown below, select Trust Center. Now in corresponding right pane click on Trust Center Settings button:

3. Moving on, in the Trust Center settings window, select Protected View from the left pane. Finally, uncheck/disable all options in right pane there, which are:

• Enable Protected View for files originating from the Internet

• Enable Protected View for files located in potentially unsafe locations

• Enable Protected View for Outlook attachments

Click OK, OK and then restart your system. 

转载于:https://my.oschina.net/u/942203/blog/857684