Export Excel Templates using Pivot tables

(0) Share

Report

Posted on by Patrick Friedrich

395

Hi all,

we do have a use case to work with Excel Templates including tables, pivot tables etc. for reporting purposes.

Each time we open the template and activate it in order to work with, all filters settings etc. especially in the Pivot table are gone. So it seems that it doesnt keep the filters from Excel / Pivot once uploaded.

Do you have any idea or similiar issues?

Thanks in advance

Patrick

I have the same question (0)

All responses (4)

Answers (0)

Nya 29,060 on at

Like (0)

Report

Hi Patrick,

Do you mean that you'd like to import data from an excel with filter and import the filtered rows only?

Was this reply helpful? Yes No
Patrick Friedrich 395 on at

Like (0)

Report

Hi Nya,

thanks for your reply.

We want to export data into Excel templates out of CRM in order to report them because oob dashboards arent sufficient.

The problem is that when using predefined filters in pivot tables and I try to export the data all filters inside the Pivot table are gone.

Any idea how to work around this?

Thanks

Patrick

Was this reply helpful? Yes No
Patrick Friedrich 395 on at

Like (0)

Report

any idea / update here?

Was this reply helpful? Yes No
ERPlatanos 73 on at

Like (0)

Report

I'm having a similar issue. Any ideas?

Was this reply helpful? Yes No