We will be performing a major infrastructure and web site ugprades on Friday, September 27th 8:00 am - 5:00 pm MST (UTC -7).

The website will be down during that time.

Send to Excel with equations generates OLE Automation errors

  • Roman
  • Topic Author
More
02 Aug 2021 12:39 #9900 by Roman
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 

Please Log in or Create an account to join the conversation.

  • pgilman
More
03 Aug 2021 15:00 #9906 by pgilman
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.

Please Log in or Create an account to join the conversation.

  • ryaser
More
11 Aug 2021 00:02 #9919 by ryaser
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

Please Log in or Create an account to join the conversation.

  • pgilman
More
16 Aug 2021 21:34 #9947 by pgilman
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.

Please Log in or Create an account to join the conversation.

Moderators: pgilman
Powered by Kunena Forum