While Exporting Rport i am getting an Error...

when i am trying to export the report from NAV to Excel , i am getting following Error how to resolve it…

Microsoft Dynamics NAV Classic

This message is for C/AL programmers:

An exception was raised in method Range. The OLE control or Automation server has returned error (HRESULT) -2147352567.
The component did not provide the exception description.


Are you using excel automation or excel buffer?

If itis excel automation then check wethether automation variable set properly