Send to Excel with equations generates OLE Automation errors

Hi

Every time, i try to export cashflow to Excel with equations i get "OLE Automation errors".

In the exported file all cells:

• Annual energy (kWh) (from c96)
• Value of electricity savings ($) (from c97)

are empty.

Sending without equations work fine.

I use european software Office 2019. Previously I used same setup and all I had to do was replace dots with commas, and everything was ok. 

Thank you in advance 

Hi Roman,

Please try saving as CSV instead of send to Excel. You can also Copy to Clipboard and then paste the data into an Excel file.

Best regards,
Paul.

Dear Paul,

Thank you for your valuable efforts and quick reply to any query.
as I told you before, I am facing the same problem that Mr. Roman published here, and this is a new problem/error that did not happen before.
I know that we can get the cash flow by saving the file as CVS or by copy the data to the clipboard, but I need to fix the current error that not allowed me to send the data as usual to an Excel file with the equations, and so get benefit from the standard form and equations in the SAM format.

can you help and advise? 

Best Regards 
Rami

Hi Rami,

I have not seen this problem with "Send to Excel with Equations" before.

Could you tell me what version of Windows you are using?

Best regards,
Paul.