Use sheet for multiple grid ad hoc
We have changed the Smart View Ad Hoc Behavior to Standard in Application Settings. However, when adding new ad hoc grid in an existing worksheet, the option Use sheet for multiple grid ad hoc is not available. Is there any other setting we need to change? I have looked into available Oracle documentation and didn’t find any other info. Or is this Smartview version compatibility issue? We are using is 24.200 Build 182 in Excel Microsoft 365 Apps for Enterprise. Same is observed using Smartview version 20.200 in Excel 2016 MSO 64-bit. Please note that our production behavior is still set as Normal. Thanks!