data source

  1. P

    Pivot table only picking up random parts of source data

    Hi I've created a worksheet which has two pivot tables drawing from the same source-data. So the pivot tables - both - are not reflecting the correct data. So I clicked on 'show details' - which of course - brings up another sheet showing the specific filtered data being used. The filtered data...
  2. R

    Unable to reconnect slicers after disconnecting and changing data sources

    Hi, I have many pivot tables & slicers on different sheets of my excel workbook. The file is constantly being updated(new/changing tables) by many people so my script has to update the data and all the data sources in all the pivot tables. The objective is to: 1. Dynamically identify the...
  3. F

    Pivot Table - Dynamic Data Source range change via VBA

    Hi all, Currently, I am working on the project with 7 different pivot tables stored on 7 seperate work sheets and the main sheet where i keep data extract. So I decided to use VBA that every time when I update my data extract to automate this process with the help of macros and VBA. I could...
  4. A

    Token Comma expected error - Trying to Select Data Source based on True/False

    Hi – new to the forum and (fairly) new to Power Query. I have managed to get the basics down (I think), and just started trying to tinker with the Advanced options. What I have been trying to do is download a file, based on whether or not a value on aseparate table is True/False, if it is true...
  5. R

    Data source reverts back to old selection

    On my pivot table, I click 'change Data source' and click the table range that I need and click OK. I go back to the pivot click refresh, nothing happens, go back to the Change Data Source' and the old Data source is listed. Range - 'Open PO Raw Data'!$A$1:$AB$26160 (old source) range -...
  6. F

    Importing table from Web with multiple pages

    Hi I’m working on importing a table from a web however the issue I am having is that the table is divided into pages based on the number of records . I need my my excel workbook to be able to import all the records into the workbook regardless of the fact they are dividing up into pages with...
  7. S

    Pivot table data source after exporting tabs from XLSM to XLSX

    I have a macro-enabled Excel file with many tabs on it. Four of the tabs contain Pivot tables that pull their data from one other tab. I have VB code that exports the five tabs to a specific location as an xlsx file. I make sure that the data tab is added first, then the four pivot tabs are...
  8. M

    Identify Data Source Update Complete

    Is there a way to identify when a data source has completed updating? We have a lot of processes that are sequential and require a data source to be update prior to running the next step in the process. Currently, we are basically, hitting one button and waiting the source data to update, then...
  9. H

    Cell Formatting Based on Data Source

    I would like to be able to run a macro which automatically formats cells based on their data source. The criteria would be 1) if a cell is hard coded, color blue 2) if a cell contains a formula, color black, 3) if a cell contains a link to another worksheet or workbook, color green. Let me...
  10. C

    Excel Graph Data always resets on reopening

    Hello, I have an odd situation, that I hope can be fixed vs. just an excel glitch. I have a table with data. From this data, I have several column charts created, representing the WoW data. When I go into Select Data Source, on the left (Legend Entries) I have the 4 locations, on the right...
  11. T

    Bug: Pivot Tables: Sources: Can't change the source of Pivot-Tables anymore

    Hi, while I'm new to this forum, I'd call myself pretty advanced when it comes to Excel. But since some days I have a problem with Pivot Tables. I'm working with Excel 2016. When I try to change the source of a Pivot Table from one sheet to another, Excel just doesn't do it. It either keeps...
  12. freelensia

    Manage external data source locations in Excel when sharing the file across Dropbox

    When working in Excel, sometimes we have external data sources. In Windows, these files may be stored in a specific location such as C:\Users\Freelensia\Dropbox\data source.xls When sharing the main file and the data source file with another person through file-sharing services such as Dropbox...
  13. L

    VBA to update file path for pivot

    Hi I was wanting a vba code to update the data source for a pivot in a file so that it points to the current month. E.g, I have a file called 'Manufacturing Month end May 2017'. This file is saved under C:/Accounts/May 17. There is a pivot in that file pointing to[C:/Accounts/May 17/Raw...
  14. L

    Removing Excel database links from master mailmerge Doc

    Good morning all from NZ. I have a master doc linked to a SS database and every now and then server administrators and managers move folders around upsetting the links. When I opened the document it hung looking for the link and I had to copy folder back to original place then re-link the SS...
  15. L

    Copying formul down a column. Data source keeps changing

    Hi, I want to copy a formula down a columns to about 200 cells. This is the formula; =IFERROR(VLOOKUP(I5,A5:C330,2,0),0) The only thing that should change is the row for I. So it should look like this =IFERROR(VLOOKUP(I5,A5:C330,2,0),0) =IFERROR(VLOOKUP(I6,A5:C330,2,0),0)...
  16. E

    PowerBI refresh fail - Expression Error.

    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...
  17. A

    Run Time Error 13 when updating Data Source for OLEDB connection

    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...
  18. A

    Change data source in pivot table

    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"...
  19. P

    Table Data Source

    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...
  20. F

    All Formulas return #VALUE error when spreadsheet is reopened

    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...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top