Tried the new Addin, great improvements vs. 3.0 but still the same constraint of 1M cells. With that, I think we really need to have a Line Item filtering function to be able to control # of lines to download. Will this function be added? Thanks.
Thank you for your comments and suggestions. First of all, I'm not talking about the dimensional filtering. Instead, the challenge is on filters based on line item values (for a given line).
Understand your workarounds on the saved view. However, many line item filters are user-functions on the dashboards (i.e. filter 'published' on dashboard with sync to the module view). It is not realistic to ask users first change the filter on dashboard, then refresh Excel. Ideally, they should be able to change their filters in Excel directly. Don't you agree?