{"id":270,"date":"2020-05-25T12:22:25","date_gmt":"2020-05-25T19:22:25","guid":{"rendered":"http:\/\/207.6.222.179\/?p=270"},"modified":"2020-05-30T14:09:46","modified_gmt":"2020-05-30T21:09:46","slug":"how-to-fix-microsoft-excel-cannot-open-or-save-any-more-documents","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=270","title":{"rendered":"How to fix &#8220;Microsoft Excel cannot open or save any more documents &#8230;&#8221;"},"content":{"rendered":"\n<p><strong>&nbsp;How to fix &#8220;Microsoft Excel cannot open or save any more documents &#8230;&#8221;<\/strong><\/p>\n\n\n\n<p><strong>Applies to:<\/strong><br>Excel 2016, 2019, Office365<\/p>\n\n\n\n<p><strong>When I have @RISK open, and try to open a file using File&nbsp;\u00bb Open in Excel&#8217;s menu, I get this error:<\/strong><\/p>\n\n\n\n<p><strong>Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space.<\/strong><\/p>\n\n\n\n<p><strong>\u00b7 To make more memory available, close workbooks or programs you no longer need.<\/strong><\/p>\n\n\n\n<p><strong>\u00b7 To free disk space, delete files you no longer need from the disk you are saving to.<\/strong><\/p>\n\n\n\n<p><strong>The same thing happens if I double-click an Excel file in Windows&#8217; File Explorer while @RISK is open in Excel.<\/strong><\/p>\n\n\n\n<p>1,<\/p>\n\n\n\n<p>if this error shows for a local file, the actual problem has nothing to do with disk space. Excel is trying to display a security warning about the file you want to open, but for some reason, it is unable to. Security warnings typically come for files you downloaded from the Internet, but not always. To work around this problem, you need to answer the security prompt before Microsoft Excel tries to display it. There are two methods to do this:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Method 1 (by file):<\/strong>&nbsp;Before trying to open the file in Excel, find it in Windows&#8217; File Explorer. Right-click the file and select&nbsp;<em>Properties<\/em>. At the bottom of the&nbsp;<em>General<\/em>&nbsp;tab, click the&nbsp;<em>Unblock<\/em>&nbsp;button. Once you unblock a file, Windows should remember and Excel should not ask you again.<br>This option is available for some file types, but not others. If you don&#8217;t have an&nbsp;<em>Unblock<\/em>&nbsp;button, use Method 2.<\/li><li><strong>Method 2 (by folder):<\/strong>&nbsp;This option is better if you usually store your downloaded Excel files in one folder. In Excel, click&nbsp;<em>File<\/em>&nbsp;\u00bb&nbsp;<em>Options<\/em>&nbsp;\u00bb&nbsp;<em>Trust Center<\/em>&nbsp;\u00bb&nbsp;<em>Trust Center Settings<\/em>&nbsp;\u00bb&nbsp;<em>Trusted Locations<\/em>. Click&nbsp;<em>Add new location<\/em>. Browse to the folder where you store your Excel files, select&nbsp;<em>Subfolders of this location are also trusted<\/em> and click&nbsp;<em>OK<\/em>.<\/li><\/ul>\n\n\n\n<p>2, <\/p>\n\n\n\n<p>If this error shows up as from a network shared folder<\/p>\n\n\n\n<p>For example, a locations\u00a0like this: \\\\192.168.1.20\\public is not trustworthy.<\/p>\n\n\n\n<p>You may need to disconnect and re-connect with the computer name like this: \\\\MyServer\\public. That is trustworthy.<\/p>\n\n\n\n<p>3,<\/p>\n\n\n\n<p>If these errors show up as Office trust settings prevent you from opening untrusted files. Both for Excel and Word, the same solutions for both, please see below.<\/p>\n\n\n\n<p>Follow these steps to get rid of this error:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Open\u00a0<strong>Microsoft  EXCEL orWord<\/strong><\/li><li>Go to\u00a0<strong>File -> Options<\/strong>\u00a0->\u00a0<strong>Trust Center<\/strong>.<\/li><li>Now click on\u00a0<strong>Trust Center Settings<\/strong>.<\/li><li>Click\u00a0<strong>Protected View<\/strong>\u00a0in the left pane.<\/li><li>Now uncheck the box:\u00a0<strong>Enable Protected View for Outlook attachments<\/strong>.<\/li><li>Click\u00a0<strong>OK<\/strong>\u00a0to save changes in Trust Center window.<\/li><li>Click\u00a0<strong>OK\u00a0<\/strong>in Excel\/Word Options.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;How to fix &#8220;Microsoft Excel cannot open or save any more documents &#8230;&#8221; Applies to:Excel 2016, 2019, Office365 When I have @RISK open, and try to open a file using File&nbsp;\u00bb Open in Excel&#8217;s menu, I get this error: Microsoft Excel cannot open or save any more documents because there is not enough available memory <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=270\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[],"class_list":["post-270","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=270"}],"version-history":[{"count":0,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/270\/revisions"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}