pivot 2007

I have a Pivot Table in Excel 2007 I'm trying to use it to display max lead times for components being brought into a business. I have a large spreadsheet with raw data, and the last col of that sheet is the lead times. These lead times are vlookuped off another sheet and then the Pivot Table...

I have 8 pivot tables with 5 pages (dropdowns) on a worksheet called Pivots I want all 8 pivot tables to display the same thing without manually going through and changing each one. The differences between the tables are the values shown. There is a link here to the sort of thing I am tryin...

Hi, Hoping someone can help with the following question Sample Data <table border="0" cellpadding="0" cellspacing="0" width="203"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64">...

In the code below, I basically copy a region of data, paste it into another workbook, and create a pivot table. I'm just not sure how to set up the source of the pivot table so that it covers the exact range that I pasted. TableDestination should ideally be a named range that is equivalent to...

I have a pivot table of data that was pulled from and SQL server. The fields have a several properties. I need to examine the value in one of the properties ("Period End Date") to determine which field to start my charts with each period. Right Clicking on the Field the Pop-up menu has a...

I have 3 sheets, all with the same headings. I need a pivot table which can take the data from all three sheets. <TABLE style="WIDTH: 326pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=435><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 62pt...

I'm working in Excel 2007 and have an issue with my pivot table killing my data validation dropdown. Please Help!!!! I have a data validation dropdown on the same page as a pivot table. If I refresh my pivot table, my drop-down option for my data validation list no longer exists. I then have...

I am a macro Newbie. I am trying to create a macro that creates a pivot, I get an error at this step: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "170_DESC_RECON_DATA!R2C1:R3068C9", Version:=xlPivotTableVersion12). _ CreatePivotTable...

I can't believe I couldn't find a solution to this on the board... I created a macro that manipulates data on a worksheet with a pivot table. Now the users want to hide that particular worksheet so it can't be altered (it feeds a graph, so that's the worksheet they want to be "active"). Below is...

I have a macro that filters a pivot table, resorts, then copies data to another area for more calculations. I need to always move the "(blank)" elements of the first column of the pivot table ("A") to the bottom of the range once filtered. I know I can use...

I have a dataset of over 35,000 rows, crossing multiple salesmen. I would like to build a Pivot table for only one of those salesmen. I know I can use a filter in the pivot table, however I do not want the salesman to be able to select another salesmans number to display sales, Cost, and GP. Is...

code snippet: If Range("ReportDate").Text = Range("Milestone_1st").Text Then ActiveWorkbook.Names.Add Name:="PassedAsOf_1st", RefersToR1C1:="=" & Range("TotalPassed").Text ElseIf Range("ReportDate").Text = Range("Milestone_2nd").Text Then ActiveWorkbook.Names.Add...

I am trying to analyze data in multiple worksheets using a pivot table. At this time I have Excel 2007 on my machine but believe I need 2010 with Power pivot to do this. Can it be done it 2007? If I must download 2010, can I run 2007 on my desktop as well as 2010 Excel so as not make the...

Hi I am trying to calculated a weigted average age in a pivot table. My input data looks something like this: Age Type Count 30 1 10 30 2 1 30 3 4 40 1 20 40 2 5 40 3 10 And I want a pivot table that lists: Type Average...

Hi I have an excel sheet with data about products and live web url links. The data is Part#,Description,Price,Category and a live web URL. When the users click on the URL it takes them to the actual web page. When I pivot the same data, the URL links get converted to text and donot have a click...

Hi - I'm getting to grips with Pivot tables in Excel 2007 and I do like some of the new functionality. However, I'm having some trouble with sorting page items so that the values appear in A-Z order. My data set is 'changeable' and I want the values in the page items to always list the...