Posted to microsoft.public.excel.misc

JMay

external usenet poster

Posts: 468

Pivot Table Refresh

If I Apply an auto-filter to the data-source of my Pivot Table
It does not effect to refreshed results of my PT.

Can someone confirm this -- that is from a Pivot table data-sources
records - any hidden rows (from an auto-filter) do not get omitted.
The PT uses ALL record, Hidden or not..
TIA,

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
Create refresh button in worksheet to refresh Pivot Table Data	Ron	Excel Worksheet Functions	1	October 13th 07 01:20 AM
Pivot Table refresh	BK	Excel Discussion (Misc queries)	3	June 12th 07 01:57 PM
refresh a new worsheet on pivot table refresh	[email protected]	Excel Worksheet Functions	0	February 9th 07 07:39 PM
Pivot Table Refresh	Carl	Excel Worksheet Functions	2	August 8th 06 03:42 PM
Pivot table refresh	nc	Excel Discussion (Misc queries)	7	September 28th 05 01:54 PM

All times are GMT +1. The time now is 07:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us