LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Refresh a PivotTable using VBA (SQL generated Pivot)

Pete, when the PivotTable is created there is no option to Refresh it
when I right click on it. The items you suggested make sense, but they
don't work the way this is set up. I was curious if I have to have this
re-connect first to get the data and then refresh the Pivot with the new
data. I guess for now I'm still stuck on this one.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
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
Pivottable refresh in shared workbook mkeener Excel Discussion (Misc queries) 2 January 14th 09 04:17 PM
How to refresh a Scenario PivotTable Report? Gerry Excel Discussion (Misc queries) 9 June 1st 08 08:12 PM
Refresh and PivotTable with Analysis Services Marco Russo Excel Worksheet Functions 2 August 8th 07 04:20 PM
disable pivottable refresh message andrewCH Excel Programming 0 November 12th 03 10:29 AM


All times are GMT +1. The time now is 12:18 PM.

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"