LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Need a time stamp on Pivot Table refresh event

Thanks Dave. No suggestions is a bad suggestion. I'll take them
all into account and see what works best.

I don't put the source data on one sheet and have the pivot table on
another. The pivot table refreshes upon opening and pulls the
current info from the database into the pivot table. This is set
based on an option in table options. I'm probably going to change
this and create a macro to refresh and timestamp on open.

I also had a suggestion to check out a web site, which has some
great info. Thanks Shailesh.


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.8 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create refresh button in worksheet to refresh Pivot Table Data Ron Excel Worksheet Functions 1 October 13th 07 01:20 AM
Help with Worksheet_Change event time stamp Little Penny Excel Programming 3 December 1st 06 11:21 AM
Timing of automatic query refresh and macro pivot table refresh dutty Excel Programming 2 December 1st 04 07:19 PM
Pivot Table Refresh VBA Event keepitcool Excel Programming 0 October 6th 03 04:31 PM
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH Ken Roberts Excel Programming 3 September 11th 03 06:02 AM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"