{"id":12917,"date":"2020-01-15T14:06:35","date_gmt":"2020-01-15T05:06:35","guid":{"rendered":"https:\/\/www.eformsign.com\/en\/support\/?post_type=manual_kb&#038;p=12917"},"modified":"2020-01-29T16:33:26","modified_gmt":"2020-01-29T07:33:26","slug":"execute-is-not-working-in-oz-in-excel","status":"publish","type":"manual_kb","link":"https:\/\/www.eformsign.com\/en\/support\/knowledgebase\/execute-is-not-working-in-oz-in-excel\/","title":{"rendered":"Execute is not working in OZ in Excel"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"320\" height=\"212\" src=\"https:\/\/www.eformsign.com\/en\/support\/wp-content\/uploads\/sites\/6\/2020\/01\/Preview-loading-takes-forever.gif\" alt=\"\" class=\"wp-image-12919\" \/><\/figure><\/div>\n\n\n\n<p>Sometimes (or rarely) when using OZ in Excel, the EXECUTE function freezes the Excel itself. The EXECUTE loading percentage sometimes does not proceed over 0%.<\/p>\n\n\n\n<p>In this case, you might want to check the size of the excel sheet. If the sheet&#8217;s size is too large, OZ in Excel tries to convert all the sheets into its form, which freezes Excel. Here is how to solve this.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2>Delete unnecessary active cells<\/h2>\n\n\n\n<p>If the scroll bar is too small, it means the sheet is unnecessarily large. Please select unnecessary cells then delete them.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1183\" height=\"709\" src=\"https:\/\/www.eformsign.com\/en\/support\/wp-content\/uploads\/sites\/6\/2020\/01\/How-to-delete-useless-cells-in-excel.gif\" alt=\"\" class=\"wp-image-12920\" \/><\/figure>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ol><li>Select the first row of the unused sheet.<\/li><li>Drag all the way down to the bottom of the sheet.<\/li><li>Select the last row of the sheet while holding shift.<\/li><li>Check the selected range once again.<\/li><li>Click right click of the mouse.<\/li><li>Select delete to delete all the selected rows.<\/li><li>Repeat this process for the column.<\/li><li>Save the document, then EXECUTE again.<\/li><\/ol>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2>Set Print Area<\/h2>\n\n\n\n<p>Also, you can fix this freezing problem by setting the Print Area.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1368\" height=\"864\" src=\"https:\/\/www.eformsign.com\/en\/support\/wp-content\/uploads\/sites\/6\/2020\/01\/Setting-print-area.gif\" alt=\"\" class=\"wp-image-12921\" \/><\/figure>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ol><li>Select the active sheets.<\/li><li>Select Page Layout on the ribbon menu.<\/li><li>Print Area &gt; configure print Area.<\/li><li>Click EXECUTE button on OZ in Excel ribbon menu.<\/li><\/ol>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"template":"","manualknowledgebasecat":[56,52],"_links":{"self":[{"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/manual_kb\/12917"}],"collection":[{"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":1,"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/manual_kb\/12917\/revisions"}],"predecessor-version":[{"id":12922,"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/manual_kb\/12917\/revisions\/12922"}],"wp:attachment":[{"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/media?parent=12917"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/support\/wp-json\/wp\/v2\/manualknowledgebasecat?post=12917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}