When trying to distribute reports, I get the following error: Exception from HRESULT: 0x800A03EC
It will create the first report for distribution, but then errors out and no distribution occurs.
Hi Sarah.
That Excel error can result from a few different causes. The most common are a typo in a reference to a named region (as can happen when passing parameters to a report before it is distributed) or having a file open that the Distribution List is then trying to re-create.
If that doesn’t get you pointed in the right direction, I would suggest sending your report to the Velixo Help Desk ([email protected]) for analysis.
Thanks, Harry. Would you be able to expand more on “typo in a reference to a named region”? I am not sure I understand what you mean by this.
Thank you!
Sarah
When passing parameters from a Distribution List to the report (so that it is updated before being distributed), the first step is to give the cell that needs updating a name:
In this example, I assigned the name “FinPeriod” to cell B1.
In my Distibution List, I can then add a new column on the end of my table with the information for that named cell:
The header for that column MUST exactly match the name I gave the cell in my report. Notice, in this case, that there is a typo - I accidently entered “Fi****nPerod” (instead of “FinPeriod”). While, most likely, Velixo will tell me there is a problem, there are times when Excel will generate an error.
This is what I was referring to.
Thank you for clarifying! I am not using anything outside of the standard distribution list columns; so it must be something else. I will reach out to Velixo.
Thank you again for the help!