 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2006Is it possible to edit multiple pivots at one time?
Say I have 5 pivot tables that all have in the drop down menu "Geography" in A4. I would like to know if excel has a capability to select say Americas from the drop down box and the same be selected and updated for every pivot you have within the file. I thought perhaps my hitting ctrl and selecting all tabs and then selecting the geography I wanted it would work but it says it cannot do that...Does anyone know if there is a solution? There's a sample file here that you could adapt to your workbook: http://www.contextures.com/excelfiles.html Under Pivot tables, look for 'Change Multiple Page Fields' > Say I have 5 pivot tables that all have in the drop down menu "Geography" in > A4. I would like to know if excel has a capability to select say Americas > from the drop down box and the same be selected and updated for every pivot > you have within the file. I thought perhaps my hitting ctrl and selecting > all tabs and then selecting the geography I wanted it would work but it says > it cannot do that...Does anyone know if there is a solution?  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html I am going to have to buy your book. SignatureHTH... Jim Thomlinson > There's a sample file here that you could adapt to your workbook: > [quoted text clipped - 8 lines] > > all tabs and then selecting the geography I wanted it would work but it says > > it cannot do that...Does anyone know if there is a solution? Thanks! <g> > I am going to have to buy your book. SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Sorry there is no easy solution. Depending on what version of Excel you are using (above Excel 2000) you could catch the pivot table change event and update the other pivot tables accordingly... SignatureHTH... Jim Thomlinson > Say I have 5 pivot tables that all have in the drop down menu "Geography" in > A4. I would like to know if excel has a capability to select say Americas > from the drop down box and the same be selected and updated for every pivot > you have within the file. I thought perhaps my hitting ctrl and selecting > all tabs and then selecting the geography I wanted it would work but it says > it cannot do that...Does anyone know if there is a solution? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.