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

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top