Excel add in Filter: Select all to include future new items

[xin]

Hi,

With pivot and filter in Excel add-in, I can select all in the list. But If I add a list member later (e.g. FCT5 2020), it is not automatically added when I refresh the connection. It would be very helpful and essential if it can automatically reflect new list items when refreshing so we do not need to update the filter every time. (It is very easy to miss new items if the list is constantly updated) Thanks!

/Xin

[MagaliP]

Have you tried changing the setting "Insert new items on refresh (excluding saved module views)"? More information about settings

[xin]

@MagaliP Thank you! I will try it.

[MagaliP]

Unless @xin confirms otherwise, this functionality already exists