Excel Export

1.83K views
0

I have Quantrix Standard 2.0 and Excel 2003 with SP2. My problems are the following:

1. When I try to export a model to Excel I don’t get the option to export it with formulas.
2. I have created a Sales Budget Model with 2 X 3 dimensions and when I try to export it in Excel I get an export error saying “Problem encountered exporting file”. I have narrowed the problem to a specific matrix that can’t be exported. I would appreciate any assistance.

Markos Brotzakis

0

After further investigation we discovered that the matrix that was being exported to Excel had more than 256 columns therefore running into the column limitation that an Excel spreadsheet has.

-Mike

0

Hello – Thank you for posting.

Quantrix Standard Edition does not offer Excel Export with Formulas. I have emailed you off-forum with possible resolutions.

In regards to the matrix not exporting properly… In your Quantrix Modeler installation directory (typically c:program filesquantrix modeler) this should be a file called ‘output.log’. Launch Quantrix, export the problem file and after the failure, please email this log to [email:1cu4ser1]support@quantrix.com[/email:1cu4ser1]. It should contain information that will help us diagnose the problem. If you can forward the Quantrix model file itself that would be helpful as well.

-Mike

Latest Questions