Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

List PivotTables

I am working with a spreadsheet that contains 15 pivot tables, and I am
writing a macro to update them programatically. Is there a way to list ALL
the pivot tables in a sheet without actually going to them and
right-clicking, going to Table Options and seeing the name there? TIA
--
Greg Tan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
PivotTables	Gerry Verschuuren	Excel Discussion (Misc queries)	4	October 25th 07 01:12 AM
PivotTables	KerryK	Excel Discussion (Misc queries)	2	October 8th 07 07:06 PM
Create a summary list without using PivotTables?	Jaye	Excel Worksheet Functions	8	October 27th 05 03:30 AM
New to Pivottables- need help	coal_miner	Charts and Charting in Excel	1	June 6th 05 06:48 PM
PivotTables/VBA	jngi[_3_]	Excel Programming	2	September 24th 04 12:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us