i am filing gstr 9c form .file is duly validated but when we are clicking on generate json file then following error is coming Microsoft excel is waiting for internet explorer to complete an Ole action.Any possible solution.
23 January 2020
Prepare GSTR9 Excel Sheet and validate all sheets. close all programs Then (1) go to the downloaded utility folder. in this folder one file named wsweb. (2) open this file with internet explorer. At bottom a pop up will ask you and a button which show allow blocked contents. Press It. (3) Insert Digital signature in computer. make sure that emsigner is running. you can check if from notification area bottom right hand side of computer clock. (4) Now open the excel file. Enable macros if microsoft office version 2007. then press Generate JSON file button. (5) a pop and save window will open press save button to save the file (6) after pressing save button Internet explorer will open again with title Invoke signing from emsigner. (7) At bottom there shall be the pop up again with button for allow blocked contents. press it. (8) Now press Initiate signing a window will aksed for ready to sign press ok (9) now press open emsigner button. emsigner will open. Just sign and the file should be ready. If internet explorer is not open automatically then close all programs. Open Internet explorer. press alt and T and go to bottom most and select internet option. select programs tab and select make internet explorer default browser.
27 July 2024
The error "Microsoft Excel is waiting for Internet Explorer to complete an OLE action" typically indicates a problem with how Excel and Internet Explorer (or its components) are interacting. This issue can occur in various scenarios, including while generating a JSON file in the GSTR-9C form if Excel is being used in the process.
Here are some steps you can take to resolve the issue:
1. **Update Software**: Ensure that both Microsoft Excel and Internet Explorer (or Edge if it’s used as a replacement) are updated to their latest versions. Sometimes, compatibility issues between outdated software can cause such errors.
2. **Restart Applications**: Close both Excel and Internet Explorer, then restart them. Sometimes, simply restarting the applications can resolve temporary issues.
3. **Check Add-Ins and Extensions**: - In Excel, go to **File > Options > Add-Ins** and check if there are any add-ins that might be causing conflicts. Disable them temporarily and try generating the JSON file again. - If you have browser extensions in Internet Explorer that could be interfering, try disabling them temporarily.
4. **Adjust Security Settings**: - In Internet Explorer, go to **Tools > Internet Options > Security** and adjust the security settings. Sometimes, setting the security level to a lower setting (e.g., Medium) can resolve the issue.
5. **Repair Office Installation**: You can try repairing your Microsoft Office installation. Go to **Control Panel > Programs and Features**, select Microsoft Office, and choose the option to **Repair**.
6. **Use an Alternative Browser**: If Internet Explorer is causing issues, try using Microsoft Edge or another browser that might be compatible with the software you're using.
7. **Check for Software Conflicts**: Ensure no other software (e.g., other office tools or third-party applications) is conflicting with Excel or Internet Explorer.
8. **Clear Temporary Files**: - Clear the browser cache and cookies in Internet Explorer. - Clear temporary files on your computer (you can use tools like Disk Cleanup).
9. **Check Excel Settings**: - Go to **File > Options > Advanced** and scroll to the **General** section. Uncheck **"Ignore other applications that use Dynamic Data Exchange (DDE)"** and restart Excel.
10. **Update or Reinstall**: If the problem persists, consider updating or reinstalling the software related to the generation of the JSON file.
If none of these steps resolves the issue, it might be helpful to consult with the support team for the GST software you are using, as they might have specific troubleshooting steps or updates that address this error.