{"id":11380,"date":"2022-02-01T17:32:00","date_gmt":"2022-02-01T08:32:00","guid":{"rendered":"https:\/\/www.eformsign.com\/en\/blog\/?p=11380"},"modified":"2022-05-20T14:51:26","modified_gmt":"2022-05-20T05:51:26","slug":"form-previewing-is-not-working-in-oz-in-excel","status":"publish","type":"post","link":"https:\/\/www.eformsign.com\/en\/blog\/form-previewing-is-not-working-in-oz-in-excel\/","title":{"rendered":"Form previewing is not working in OZ in Excel"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img 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>When using OZ in Excel, although this happens very rarely, the Execute feature for form previewing will freeze Excel and the loading percentage will not go over 0%.<\/p>\n\n\n\n<p>In this case, you can resolve the conversion issue by defining the range of the Excel sheet. You can use one of the two methods below.<\/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 and then delete them.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img 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 empty row outside of the document area.<\/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>Right-click on the mouse.<\/li><li>Select Delete to delete all the selected rows.<\/li><li>Repeat this process for columns.<\/li><li>Save the document, then click 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 the print area<\/h2>\n\n\n\n<p>Also, you can fix this freezing issue by setting the print area.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"1487\" height=\"1019\" src=\"https:\/\/www.eformsign.com\/en\/blog\/wp-content\/uploads\/sites\/3\/2021\/10\/printing-area.gif\" alt=\"\" class=\"wp-image-11481\" \/><\/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 sheet area.<\/li><li>Select PAGE LAYOUT in the ribbon menu.<\/li><li>Select Print Area &gt; Set Print Area.<\/li><li>Click the Execute button in the OZ in Excel ribbon menu.<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>When using OZ in Excel, although this happens very rarely, the Execute feature for form previewing will freeze Excel and the loading percentage will not go over 0%. In this case, you can resolve the conversion issue by defining the range of the Excel sheet. You can use one of the two methods below. Delete [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":12250,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[129],"tags":[165,154,155,182,187],"_links":{"self":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts\/11380"}],"collection":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/comments?post=11380"}],"version-history":[{"count":5,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts\/11380\/revisions"}],"predecessor-version":[{"id":11689,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/posts\/11380\/revisions\/11689"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/media\/12250"}],"wp:attachment":[{"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/media?parent=11380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/categories?post=11380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eformsign.com\/en\/blog\/wp-json\/wp\/v2\/tags?post=11380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}