Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default pivot table refresh macro

I have a large spreadsheet with many pivot table reports. I want a macro
that will update all of them with one click of the mouse.

Any help?

Thanks.

Kevin
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default pivot table refresh macro

Choose ViewToolbarsExternal Data
Click the Refresh All button.

This will refresh all the pivot tables and external ranges in the workbook.

kraway wrote:
I have a large spreadsheet with many pivot table reports. I want a macro
that will update all of them with one click of the mouse.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default pivot table refresh macro

You could also record the sequence of steps Debra gives below and assign that
macro to a button.

Dave
--
Brevity is the soul of wit.


"Debra Dalgleish" wrote:

Choose ViewToolbarsExternal Data
Click the Refresh All button.

This will refresh all the pivot tables and external ranges in the workbook.

kraway wrote:
I have a large spreadsheet with many pivot table reports. I want a macro
that will update all of them with one click of the mouse.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Reply
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
Pivot Table Size PCStechnical Charts and Charting in Excel 0 October 12th 06 06:25 PM
Auto refresh pivot table Eleanor M Excel Discussion (Misc queries) 3 September 12th 06 08:54 PM
Pivot Table Refresh Deletes Range On Different Sheet TMore Excel Discussion (Misc queries) 0 August 17th 06 01:55 PM
Refresh scenario information in a pivot table Fin Analyst Excel Discussion (Misc queries) 2 March 30th 06 05:13 PM
Macro to Modify Pivot Table for Color and Bold Cheryl B. Excel Worksheet Functions 1 July 7th 05 03:52 PM


All times are GMT +1. The time now is 11:20 AM.

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

About Us

"It's about Microsoft Excel"