Form previewing is not working in OZ in Excel

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 unnecessary active cells

If the scroll bar is too small, it means the sheet is unnecessarily large. Please select unnecessary cells and then delete them.

  1. Select the first empty row outside of the document area.
  2. Drag all the way down to the bottom of the sheet.
  3. Select the last row of the sheet while holding shift.
  4. Check the selected range once again.
  5. Right-click on the mouse.
  6. Select Delete to delete all the selected rows.
  7. Repeat this process for columns.
  8. Save the document, then click Execute again.

Set the print area

Also, you can fix this freezing issue by setting the print area.

  1. Select the active sheet area.
  2. Select PAGE LAYOUT in the ribbon menu.
  3. Select Print Area > Set Print Area.
  4. Click the Execute button in the OZ in Excel ribbon menu.
2022-02-01

Add Comment