Scroll Position in a Pivot Table in Version 9 with a Bookmark
I have tried a number of things but cannot find a way to make this work. I am using Version 9.0SR2
I have a pivot table that the end user is using as a worklist. By selecting a name it opens another set of tables/charts with additional information on the individual. Unselecting the name takes the user back to the original pivot table list. This is done with bookmarks and a macro. It all works fine except that when the user gets back to the original list the scroll always goes back to the top. The user wants it to return to the last name that was used.
I have checked the "Preserve Scroll Position" on the layout tab and have tried both checking and unchecking the Preserve scroll position on the bookmark.
I also looked at using an Inputfield so that the user could mark them as "done" and so eliminate them from the list but the inputfield does not work in the pivot table and even if I used a table it doesn't easily let me filter on the value.
Any ideas on how to accomplish this, either with the scroll position or with somehow marking names as completed and shrinking the list or some other option ? Any help would be greatly appreciated.
