Excel 2017 Addition in Anaplan

Hi Team,

Is there any plan to add Excel 2007 option when we export data from dashboards. We have data more than 60K and excel option will not allow us to export complete data. To be more specific, we don't want to see it in CSV and text.

Regards,

Devika

Accepted answers

All comments

Adithya S

Hi @Devika,

It depends on the export action that you have set to export. For example:- If you have set the export action to export as Excel.xls it will export it. Also, I am sure that the limitation is not just 60k records, because I have worked with far more than that. So, if you don't want csv or txt as export, you can set it as Excel.xls. You have to save the export definition and set it up in a process and publish it in the dashboard.

Hope this helps.

Regards,

Adithya S

Devika

Hi Aditya,

Thanks for your reply. Here I am attaching a screen shot which I am getting while exporting data from dashboard. I was trying to create an export definition and its throwing me the error (Error 1 screen shot). There is a limitation for excel but not for xlsx (Excel 2007+). That's the reason I am asking for any updates on excel version upgrade.

Regards,

Devika

Error 1.JPG

Adithya S

Hi @Devika,

I am sure that you are using excel format export for some specific purposes. However, is not possible for you to use the export formats? They literally serve all purposes. Yes, I tried the method you said and it seems to me that it is the case. Drop a mail to the Anaplan support team and you will get a quick response. Although, I would still suggest you use the other export formats which serve all purposes. If you still want to use the same format and need a workaround, I think we can manage that. Let me know how it goes.

Regards,

Adithya S

Hi @Devika,

The export options provided by Anaplan are Excel(.xls) and Excel(.xls without formatting). Now, what you have used is Excel(without formatting) option to export your file. The latter option is of Excel 97-2003 workbook, which means that it was an old version and the limit of rows back then was 65536. Whereas, above the excel 2007 and other versions have the limit 1,048,576. I did download the Excel(without formatting) and later checked the properties after the download. In the properties, it is indicating the file property as 'Microsoft Excel 97-2003 worksheet'. What you were using was an older Excel version export.

So to speak, Anaplan had already given both the options for you to choose from. Whether you want it as Excel workbook or not, the option was already there to choose from.

Hope this helps and solves your answer.

Regards,

Adithya S

Devika

Hi @Adithya S,

Which meanes you are able to export data (more than 65k rows) in xls format. isn't it? If that the case, not sure, why I am getting the error even in xls format.

In short, I have tried both options (xls and xls without formatting). Both are showing me the limitation of row count.

Regards,

Devika

Adithya S

Hi @Devika,

Oh my bad, yes it seems to me that it is the case as you said. Try the below link and post your query to Anaplan enhancement team. Also, drop a mail to support. Let me also dig around a bit to get the solution for this.

https://community.anaplan.com/forums/-/message_boards/category/37848

Regards,

Adithya S

Devika

Hi @Adithya S,

I don't have access to "Start a Topic" on the link which you have provided. However, I will send a note to support team.

Once again Thank you so much for getting back to me.

Regards,

Devika

Quick Links

Can you help?

Unanswered questions

UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?