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

0 Kudos

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

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

xin_0-1613576939258.png

 

3 Comments
MagaliP
Community Boss

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

xin
Contributor

@MagaliP Thank you! I will try it.

MagaliP
Community Boss

Unless @xin confirms otherwise, this functionality already exists

Status changed to: Delivered
Users Online
Currently online: 499 members 1,086 guests
Please welcome our newest community members: