data source

Hi, I am unable to refresh my powerbi data online since the last update. Have checked and made sure my personal gateway is up and working. Other Datasets working ok as well. Have one dataset that is reporting an error Data Source Error: [Expression Error] The name...

I wanted an easy way for a user to change the file path for an excel report that gets run every day. The workbook I'm building is bringing the data from that separate report into a worksheet via an OLEDB connected Table. To do so, I recorded a macro to change the location. Then I modified the...

I am trying to change data source of pivot table. Below is the code. Dim data1 As PivotCache Dim PT2 As PivotTable Sheets("carrierresponse_list").Select Set data1 = ActiveWorkbook.PivotCaches.Create(xlDatabase, Sheets("carrierresponse_list").range("A1"...

HI, suppose you hear this allot but I do not have an in depth knowledge of excel. I have search extensively for an answer to my problem but cant find one. Problem: I have a excel workbook which contains all the different products that I stock in my shops. I want this sheet to populate each...

I am using Windows 7 Excel 2010. I have a two-tab workbook, let's call them "A" and "B". A pulls all it's data from B through formulas. We realized B is no longer correct data, so we regenerated this report, which created a new worksheet called "C". We pulled in this worksheet to the...

Hi All, I've encountered an annoying thing in Excel 2013. I'm using pivot tables a lot, hence i'm creating template files, so all i need to do is to 'save as' the workbook, copy new data and refresh the pivot tables. The annoying thing is that for whatever reason the data source points to the...

This may seem as a dumb question, but is there anyway I could set up a pivot table as a linked table on power pivot? Thanks in advance!

I noticed that when I click on a cell in my Pivot Table a new worksheet pops up with the requested information (essentially a filtered version of my data source depending on what cell I clicked) is there a way for that information to appear on the same worksheet as my Pivot Table? And if so can...

Hi! I have a Table with an ODBC connection and from that table, I have multiple sheets with "Pivot tables" (with their respective "Dynamic Chart"). What I want is to change the query and then refresh just one Pivot table at time, but when I refresh one Pivot table all the “Pivot tables"...

Hi there! I have a workbook with dozens of pivot tables defined, and their data sources are set to named ranges in various worksheets within the same workbook. Due to a change in customer requirements (don't you love those!), I now need to bust the detailed data out into separate workbooks...

I have a doucment with many sheets, one pivot table per sheet. I would like to use a macro to change their data sources all at once to the same data source. I found this code wich I would like to use as the data source..this ensures there are no extra empty cells (which causes my Value Field...

Okay, as you can tell from my number of posts, I'm new to this, but the results I've gotten have been OUTSTANDING. Here is my question: Software: Excel 2003 W/7 with destination machine Excel 2007 XP. This is a golf tournament scoring program that handles a wide variety of tournament...

I'm very familiar with pivot tables, slicers and dashboarding, but looking for some guidance regarding data source setup and configuration. Our data sources are updated daily, and I'd like to know the best way to connect slicers to the data source to use 'refreshed'/updated data... currently we...

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Situation : I have an exel worksheet wich contains 2 sheets. The first is the data and second contains 4 pivot tables. It also contains a macro that will update the Data source of all 4...

I have set up a workbook in which each worksheet contains identical information for each employee of my business, mainly achievement against targets, income earned etc. etc. Ideally I would like to summarise the key elements of each of these in a dashboard style format on the first sheet of my...

Hi, I have a report that I duplicate for different campaigns. The report contains about 20 pivot tables all based on the exact same data source (data source contained in excel). When the next campaign starts, I want to copy the old report and then change the data source on ALL 20 tables at the...

I am trying to use an Access database as a source for a pivot table. I am able to locate the database through the PTable Wizard and connect, but when I get to the point of choosing my data fields it won't let me drill down. It will show me all the tables and queries, but will not let me...

I have one workbook that contains data and another that has the graphs. I have 200 graphs that I produce each month that show a 5 year month over month trend. Each month I need to drop off the data from the very first month (December 2003) and add data for the last month (January 2009) so...

I have an advanced filter in Excel 2002 (on Windows XP). I want to automatically refresh/reapply the filter when any of the data (aka "List Range") is changed. I've done a lot of searching and experimentation and I just can't find a good solution. Please let me know if you have any thoughts or...