Im getting this error when I try to generate a preview of my excel document in nprinting:
"Index was out of range. Must be non-negative and less then the size of the collection. Parameter name: index"
My excel document have one major pivot that reads data from a couple of straight tables located on diffrent sheets in the document. I have not added any new data, I just used the original excel as a template and try to load it and the error pops up. There is no problem opening this document with excel. Anyone have any idea how to troubleshoot this problem? Im using nprinting version 18.104.22.168, /David
I faced the same issue recently, and after little research and experimentation, I can state that the problem lays in Excel Slicers. After removing them from template, it works pretty fine. If you still need Slicers in final Excel report, you may write VBA-code which creates them (using Record Macros functionality, for instance), and set Workbook-Open trigger on it. The result would be as follows: user opens the report, macros starts instantly and creates the desired Slicers dynamically.