ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Timestamp for when Pivot table was last refreshed (https://www.excelbanter.com/excel-discussion-misc-queries/201680-timestamp-when-pivot-table-last-refreshed.html)

Abi

Timestamp for when Pivot table was last refreshed
 
Is it possible to create a timestamp for when a pivot table was last
refreshed, so different users don't keep refreshing data to ensure they have
the most recent?

Joe Mac

Timestamp for when Pivot table was last refreshed
 
Why not set the option within the Pivot to refresh on open and then everytime
the file is opened it will contain the most current
--

Joe Mac


"Abi" wrote:

Is it possible to create a timestamp for when a pivot table was last
refreshed, so different users don't keep refreshing data to ensure they have
the most recent?



All times are GMT +1. The time now is 01:37 PM.

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