source data

May I request assistance on using variables within a Pivot Table Source Data property. I am receiving an error when using the following code 'Create Pivot Table off of Consolidated Employee Data Dim LR As Long Dim LC As Long LR = Range("A:AO").Find("*", SearchOrder:=xlByRows...

Hello, I need some VBA code to address the following: Scenario: A pivot table reveals a probable error in the underlying source data. The error needs to be located and corrected in the source data, and then the pivot table needs to be refreshed. *Problem*: The double-click action on a pivot...

I download data from a web site on weekly basis and break information down by branch location and employees assigned to each branch-- Data source will fluctuate depending on new hire employees and those that quit or get laid off. I used macro recorder to help create this section of VBA to help...

Pivot tables update correctly on all but one sheet.... It looks like it is sourcing another workbook... How can I get it to source the same data the other sheets are sourcing...which is in the same workbook. I am in Excel 2010.

I am writing a macro to create an xy-scatter plot. I have selected the range that I wish to plot. I have several series that I would like to be included in the plot (the specific number of series will vary each time and the number of points). I am having trouble with the...

I've built a fairly elaborate set of pivot tables based on data in one worksheet. Then, I have a "report page" which is a sheet with a pull-down to select one variable and then the sheet is populated with data from the different pivot tables. This is to produce a monthly report. I have a new...

Hey Guys I'm trying to find a VBA or Macro that will speed up such a laborous process: I have multiple pivot tables on different sheets, and multiple pivot tables on the same sheet! All with one data source, is there a way to make a code that will mean i can update the data source on all the...

Hi All, I have seen a few threads similar to my predicament, but none with a final outright solution so I'm hoping someone might have some advice for me! :) Essentially I have a mighty big PowerPoint databook with linked excel charts (each slide in the databook is linked to a respective...

There are a lot of posts out here about this, but none that quite answered my question. I have a worksheet that gets a row added to it daily with the date and other data. There is also a chart based on this sheet; currently I'm manually changing it's source data daily to reflect the new row...

I have a macro that runs on open and one of the things it does is refreshes a pivot table based off another sheet within the same workbook and that works just fine on my pc but if someone open the file from their email then they get an error: "Cannot open pivottable source file" Is there a fix...

Hello - Hoping someone can help me with my question regarding source data and pivot tables. One a tab I have columns of data which is the source data for a pivot table I have just below. For the sake of this question, lets say all of this is on "Sheet1", the data is in cells A2:F25, and the...

Hi Is there a way I can list all of the source data in all of the Pivot tables in a workbook? The reason I ask is that I have some source data that I don't think is used anywhere and I just want to delete it. Experience has taught me not to be so rash and I just wanted to ensure that it is...

Hello, I´m working on some data organized by a Pivot Table. Is it possible to link the changes I make on the PT to the original data? I do not want to change or refresh the source data, but the reverse, I need to change the original data using the Pivot table. Is it possible? How can I do...

Forgive me if I am wrong but I cannot find the answer to my question on other threads so I am going to ask. Background Info: Using - Excel 2007 through windows xp I am accessing a SQL server to retrieve a table of data. I am then using a macro to open a userform in which the user inputs data...

Can u have 10 shared workbooks using a single source workbook, for a dropdown menu; but i need to have like 5 books open at a time from different computers over a network. Plus each one needs to have a functioning dropdown option. Can this be done?

Hello, I need an advanced user on Excel 2007 pivot tables [or at least someone better than me....] <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a workbook with multiple worksheets. One worksheet has my source data and the other worksheets have...

I have a worksheet with a "Rates" column containing cells of various formats. Some are General, some are Percent, some are Currency, some are Text, etc. When this column is pulled into a pivot table, the original formatting is lost and the entire column appears in General format. Is there a way...

Hello, Currently I'm working in an excel file that contains a lot of charts. I want to write a macro that changes the source data of every serie in every chart. It only needs to add extra rows. But as every series has different columns where they get the data from, how can I change the rows...

Hi there In old Excel if I click on a link or use ctrl+[ I could go directly to the linked cell in the external spreadsheet, but in Excel 2007 all it does is open the workbook in the place it was last saved. Does anyone know how can I get Excel 2007 to go directly to the linked cell?

Hello, I have been frustrated by this problem for some time- Whenever I try to update the source for data links in 2007 (Data>Connections>Edit Links>Change Source) excel ALWAYS freezes! I've tried this on other machines as well and the same thing happens... useful info: -I am trying to change...