ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/48984-pivot-table.html)

Julie L

pivot table
 
I have a form setup as a pivot table for specific items in the source data.
Everytime there is a new item added to the source data, the pivot table will
automatically select and show the new item at the bottom of the table when I
refresh the data. Is there a way I could keep the same format (i.e. the same
item displayed in the form) no matter if there is a new item added to the
source?


All times are GMT +1. The time now is 12:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com