Hi all, I am currently facing an Export issue: non-Admin users do not get the file xlsx exported, while i can, being Admin user. Export Failed non admin.png I have checked all possible reasons: * I have checked that export action is assigned to the roles * I have set in export definition the default export file for "Everyone" * I have saved the view to only show the line item needed and top level list item ( business needs in this export the total company level only) * i have marked write selective access to top levels for this non admin users currently testing the export * I have redone from scratch the exports even. * the exported file is big one, but does not overpass the xlsx max number of lines (1,048,576) Not sure why no admin user gets attached warning and does not get downloaded the file, are there browser limits of downloads that i shall check on client's end maybe or other reasons i did not check? Thanks,

Export failed for non Admin users

Hi all,

I am currently facing an Export issue: non-Admin users do not get the file xlsx exported, while i can, being Admin user.

Export Failed non admin.png

I have checked all possible reasons:

I have checked that export action is assigned to the roles
I have set in export definition the default export file for "Everyone"
I have saved the view to only show the line item needed and top level list item ( business needs in this export the total company level only)
i have marked write selective access to top levels for this non admin users currently testing the export
I have redone from scratch the exports even.
the exported file is big one, but does not overpass the xlsx max number of lines (1,048,576)

Not sure why no admin user gets attached warning and does not get downloaded the file, are there browser limits of downloads that i shall check on client's end maybe or other reasons i did not check?

Thanks,

Accepted answers

All comments

umangsinghal

There is a known issue for Excel formats. Could you try having this file in CSV format.

Refer the below page

https://support.anaplan.com/xls-and-xlsx-exports-fail-with-a-page-limit-error-or-return-a-blank-page-c6b41bec-d815-45ca-94cb-8037f0ab1084

M.Kierepka

Hi @AndreeaCepoi,

There are few more things worth checking, please let me know if some of it worked for you:

Check access in Roles→Modules to the module you are trying to export, and any module that contains filters that are used by this export (to filter the view or tabular-multi-column export) - role of your end-user need to have at least Read access to them.
If your module has Versions dimension, check access in Roles→Versions to the Version you are trying to export - again it needs to be at least Read for the version in the view & role of your end-user.
Check how the underlying module might look from the end-users perspective - if there are some filters per user, maybe he sees no columns/rows/pages because of that, and it throws an error?

AndreeaCepoi

Hi all,

Thanks for the reply,

@Umang Singhal , client needs it xlsx (macro used for) and me , as admin i can anyway download xlsx.

@M.Kierepka 1. no filters in needed for , roles i checked for module from where is exported the data 2.no versions 3. no user dimension in.

umangsinghal

@AndreeaCepoi Is DCA applied on any lineitem you are exporting?

Quick Links

Can you help?

Unanswered questions

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385