LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Linking a pivot table filter to a control cell

Hello,

I have a report with 10 different pivot table charts - each has the same
filter which I have to change when I am looking at a diferent sector. Is
there a way of linking this into a control cell so that I only have to make
the change once?

Any help gratefully received.
 
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
Filter lines with Pivot table and non Pivot table columns Grover Excel Discussion (Misc queries) 1 September 26th 07 12:48 AM
Filter lines containing pivot table and non pivot table data Grover Excel Worksheet Functions 0 September 24th 07 07:20 PM
linking cell to Pivot Table data steph Excel Worksheet Functions 3 June 12th 07 02:05 PM
linking pivot table data to a cell in other sheet sudip Excel Worksheet Functions 3 September 13th 06 02:34 PM
GETPIVOTDA - Linking Into Pivot-table Cell LAB Excel Discussion (Misc queries) 1 March 3rd 05 01:06 AM


All times are GMT +1. The time now is 04:00 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"