source data

Hello, I work for a company that has several employees clocking in and out electronically from home. All this information gets logged into our system which then generates an excel file with fields such as member name, date, task they are working, pay period, and clock in and clock out times...

Hi So I would like know if this is possible or if there was another way to do this. I have a very large data source (750,000+ records) in an excel file. I would like to create subsets of this data based on which team it is allocated to. This is the easy part for me. So I have Team 1, Team...

Hello, The issue: At my company, we utilize SharePoint co-authored Excel workbooks to retrieve, store, and manipulate data. Aside from that being problematic in and of itself, users want to see populated data in one workbook based on data from another workbook. Essentially, a formula looks like...

Hi, We have several target sheets that run using the formula below. I have been told that they always used to work without having the source book open but from researching online i dont see how it was possible as they have always been using sumif. could you have a look at the formula below and...

So there are bunch of ways to find where excel file data is pulled from, but I found none to find where data is fed to. I want to rename an excel file, but I want to also make sure other files that are linked to that file will change the file name.

I am currently trying to link data between a large data file and a fill in form that I have created. The source data is coming from an excel file that is over 34 MB and more that 177,000 lines. This data deals with inventory shrinkage. There are 7 columns that I am accessing on the source...

Hello, I'm trying to find a seamless way to change the data source file in a pivot table without manually going in and editing the text via Pivot Table Tools -> Options -> Change Data Source. Ideally, I would somehow build a reference using a HYPERLINK-CONCATENATE formula that I build, either...

I have existing excel (ver 2010) with pivot. This excel is refreshed programmatically from c# application. The pivot is created with OBDC with sql stored procedure (which returns the sql table after performing some business logic) to pull the data. When the excel is refreshed programmatically...

First I apologize for being very new to VBA. I have two workbooks that need to stay separate. There are 4 data sources in one of the workbooks and the other workbook has several pivot tables that reference them. Each week, I need to save a new file with that week's name. Every time I do this, I...

Hi everyone! How are you? I am working on a financial report with +100 worksheets where I use a For Each loop to create charts on every worksheet. I had one that worked excellent but now that I added some extra columns to the pivottable which I don't want to add into the chart, I had to change...

I have a Pivot Table that's source is a table called "Data". In my code, I convert this table to a range, perform a variety of functions, then convert it back to a table with the same name ("Data"). I want the code to automatically update the source data of the Pivot Table to the new "Data"...

HI , I have 5 pivot tables , 3 are connected on 1st raw data and other 2 are connected on 2nd raw data and I am trying to refresh them using both Excel refreshall button or Alt+f5 and I even tried macros(activeworkbook.refreshall) but It's not working for the first try , All I need to do is to...

Hi Folks, I have been trying to use pivot table consolidation from multiple sources but didnt manage to get the desired outcome. Im happy with any hint of solution, vba or formula / wizards... I have 3 sheets in excel where you can find similar type of data at the same locations. This is...

Hello all, I've been trying to change a pre-existing excel file to make it work with different source data. It is a timesheet master file that gathers data from a set of separate excel sheets which are each individual timesheet, and builds a report based on that information. I changed the...

Hi - getting familiar with PP for the past few weeks. Got about 4 books that I've gone through, but none really address the issue of "When source data changes..." I've got a source data file where column headers change each month. It is a 36 month rolling report, so last month had "Dec 15" as...

I'm trying to adjust a reporting file that currently looks at raw data for a one week period and generates reports through pivot tables. Each week's source data has to be on its own sheet, so traditionally, a new file is created each week. Other parts of the file generate data on a two week...

Hi there, I am curious if anyone can help me with a formula that could find the source of the Pivot table and put it in a cell to show that it selected a specific range of source data. What I am doing is that I have a Pivot with VBA buttons that switches between two source data tabs, "Actual"...

Trying to get some help for a friend here. He is running Excel 2010 and has an existing chart with no data associated with it. He right clicks on the chart and clicks on "Select Data". The Data Wizard pops up and he clicks the Chart Data Range Icon (the one with the small red cell in the...

Hello all, I want to specify the active selection as the range for my pivot table but I keep getting an error message. Funny thing is this recorded code always used to work before but for some reason its not working anymore. The only change I had made in the recorded code was changing source...

Excel 2007. Trying to create a report workbook that pulls data from other source workbooks, but I would like to be able to disseminate the report workbook to other networks without including the source workbooks as they are massive. Current setup: I am having the report workbook pull data using...