Apply different bookmarks on individual Excel tabs

[#1]

Hi, this is about NPrinting Excel Report.

I have 4 excel tabs and they all point to the same chart object.

But I want different bookmarks applied to each of them, i.e., same report with different filters.

The filter function seems to be document level and can't b e applied to each tab.

Page doesn't apply in this use case.

Please help, thanks!

[Stephen_Jasionowski]

Jessica - you can filter the chart object itself on each of the Excel tabs. See the following: How to Apply a Specific Filter to Tables or Images

[#3]

Thanks Stephen, the tutorial shows filter on object level. Does that mean if I use the same object on 4 tabs, I wouldn't be able to apply different bookmarks on each tab? BM1 for tab1, BM2 for tab2, etc.?

[Stephen_Jasionowski · Accepted solution]

Jessica - add the object to the Images/Tables list 4 times (each one after the first will have an underscore followed by a number). Then drag each instance into the respective tab and apply the filter accordingly.

[#5]

Thank you Stephen! Exactly what I needed!