'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Crashing When Using Oracle Web ADI
Question details
User needs a solution for Excel crashing or hanging when attempting to upload invoices using the Oracle Web ADI integration.
- Product
- Microsoft Excel
- Device & OS
- Windows 10 version 22H2
- Scenario
- Uploading invoices or data through Oracle Web ADI.
- Observed behavior
- Excel hangs or closes unexpectedly, and the issue persists even after reinstalling Java, enabling macros, and modifying internet settings.
Before proceeding, ensure you have administrative access to your Windows computer and the Microsoft 365 Admin Center, and save any open workbooks to prevent data loss during troubleshooting.
Revert Microsoft Office to an Earlier Version
Since the crash often begins after a recent Microsoft 365 update (such as version 2403), reverting to the previous stable version can bypass the compatibility issue with Oracle Web ADI.
Microsoft Office updates can occasionally introduce compatibility bugs with third-party integrations like Oracle Web ADI. Rolling back your Office installation to the last known working build is the most reliable workaround until a patch is released.
Open Excel, go to File > Account, click on 'Update Options', and select 'Disable Updates' to prevent Office from immediately reinstalling the problematic version.
Click the Start menu, type 'cmd', right-click on 'Command Prompt', and select 'Run as administrator'.
Type the command 'cd %programfiles%\Common Files\Microsoft Shared\ClickToRun' and press Enter.
Type 'officec2rclient.exe /update user updatetoversion=16.0.xxxxx.yyyyy' (replace xxxxx.yyyyy with the build number of the earlier stable version you wish to revert to) and press Enter.
Open a Microsoft 365 Support Request
If reverting the Office version does not resolve the crash, you should escalate the issue to the Microsoft 365 support team for advanced diagnostics.
Experience Stable Spreadsheet Editing with WPS Office
If third-party add-ins and updates are causing your current spreadsheet software to crash, consider switching to WPS Office. It provides a lightweight, highly stable environment that handles large datasets effortlessly while maintaining strict compatibility with Microsoft Office formats.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package.
- 2. Install the Application: Run the installer and follow the on-screen prompts to complete the setup.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files to continue working seamlessly.
Frequently Asked Questions
Why does Oracle Web ADI cause Excel to crash?
Crashes are typically caused by compatibility issues between Oracle's Java-based integration and recent Microsoft Excel updates. Changes in Excel's security protocols or handling of VBA macros can also trigger these hangs during data uploads.
Will reinstalling Java fix the Web ADI Excel crash?
While updating or reinstalling Java is a standard troubleshooting step for Oracle Web ADI, it often does not resolve crashes introduced by specific Microsoft 365 version updates, which usually require reverting the Office installation.
How do I ensure macros are properly enabled for Oracle Web ADI?
In Excel, navigate to File > Options > Trust Center > Trust Center Settings > Macro Settings. Select 'Enable all macros' and ensure that 'Trust access to the VBA project object model' is checked.
