Ole error in json file creation for gstr 9c

Hi Siva Andhavarapu,
You're encountering a common issue that many users face during GSTR-9C JSON file generation in the Offline Utility when inserting DSC (Digital Signature Certificate) — the dreaded:

"Microsoft Excel is waiting for another application to complete an OLE action."

🔍 What This Error Means

This error is typically caused when Excel is trying to communicate with another application (like the DSC signer)via OLE (Object Linking and Embedding) — and that application either hangs, crashes, or doesn’t respond in time.

In your case, the Offline Utility is trying to trigger the EmSigner or the Digital Signature Controller, but Excel is stuck waiting.

✅ Step-by-Step Solutions

🔧 1. Enable "Ignore other applications that use DDE" in Excel

1. Open Excel (not the JSON tool).

2. Go to:

   • File → Options → Advanced

3. Scroll to the General section.

4. Check the box:
   ✅ “Ignore other applications that use Dynamic Data Exchange (DDE)”

5. Click OK.

6. Restart Excel and try again.

📝 This helps Excel stop waiting for external apps to respond.

🔧 2. Run Both Excel and DSC Signer as Administrator

• Close everything.

• Right-click on:

  • Your Excel Offline GSTR-9C Tool

  • Your DSC Utility/EmSigner

• Choose “Run as Administrator”

• Then try to generate JSON and insert DSC again.

⚠️ Required especially when using Java-based DSC utilities.

🔧 3. Temporarily Disable Antivirus or Firewall

Some antivirus software blocks the DSC interaction, thinking it's unsafe.

• Temporarily disable antivirus or firewall.

• Retry the process.

🛡️ Don’t forget to re-enable it after testing.

🔧 4. Ensure Java and EmSigner Are Correctly Installed

• Make sure you're using the correct version of Java (usually Java 8).

• Reinstall the EmSigner (or GSTN-provided DSC utility).

• You can download the latest from https://www.gst.gov.in/download/dsc

🔧 5. Use a Clean Windows Profile or Different PC

If the issue persists:

• Try on a different user account or

• Try on a different system entirely (preferably a clean Windows install with Excel and DSC utility only).

⚠️ Bonus Tip: Use the Latest GSTR-9C Offline Tool

Always download the most updated version of the GSTR-9C Excel Utility from the official GST portal.

Older versions often trigger more compatibility problems with Excel and Windows security updates.