Working on Large Grids in Smart View

Oracle Smart View for Office (Mac and Browser) may stop responding while opening workbooks with large grids.

Microsoft Excel has a data transfer limit of 5 MB for Excel add-ins used on the web.

If you try to open a workbook containing a very large grid or perform a zoom in operation in which the resultant grid exceeds this limit, then Smart View does not allow the operation and displays an error message. This is done to prevent any issues caused by crossing the limit set by Microsoft. As a workaround, you can try to adjust your selection while zooming in to ensure that the grid does not exceed the limit.

For more information, see Microsoft documentation on Resource limits and performance optimization for Office Add-ins.