Page 1 of 1

Cannot export Perf report to either Excel or OpenOffice

Posted: May 12 2021
by jval
Windows 10; MC 14 build 21357; Excel 2019; OpenOffice 4.1.10:

I can't export strategy performance report to Excel -> getting stuck in "Starting Excel application" (even for smaller, filtered report). So I installed OpenOffice but getting "Starting Calc application....; Failed to Save; All Done". Saving XML works fine (but I am not getting what I need). Anybody has the same issue.? I am using a standard, fresh Win. I tried to disable defender/antivirus, but no help (saving XML works after all).

Thanks for any help! Desperately need to extract trades' list from the strategy.

Re: Cannot export Perf report to either Excel or OpenOffice

Posted: May 17 2021
by Svetlana MultiCharts
Hello jval,

Most likely the issue is with Excel. We would recommend to try the following solutions.
1. Reinstall Excel.
2. Go to Excel -> [ALT + F11] -> Microsoft Visual Basic Editor -> Tools -> References. Check that references are configured as shown below.
excel references.png
(56.82 KiB) Not downloaded yet
3. Contact Microsoft Office support.

Re: Cannot export Perf report to either Excel or OpenOffice

Posted: May 27 2021
by jval
Thanks MC. I've done many experiments and checked all what you recommended but no luck. My issue is only happening when running MC on Win10 on Parallels (Mac VM) so there must be some dependency when using the external applications to export data. CSV export works fine. ..... any chance of MultiCharts for Mac? :-)))

Re: Cannot export Perf report to either Excel or OpenOffice

Posted: Jul 29 2021
by Vlada MultiCharts
jval,

We can give the recommendation to try launching MultiCharts and all its components as administrator.
We do not guarantee MultiCharts will work correctly on Parallels because of restrictions that can appear when you use this method. MultiCharts is a Windows app, so we run the tests on Windows only.

At the moment we don't have plans for introducing MultiCharts for macOS.