external data source

  1. Q

    Trouble creating pivot table

    I currently have a workbook that I've built utilizing macros and pivot tables to analyze a variety of data. I'm trying to create a pivot table which would be tied to an external data source (another excel workbook). the problem is that when I have both workbooks open and try to select the...
  2. A

    External sheetname variable in VLOOKUP

    Hi I've googled for hours for a solution on this, but couldn't find anything that seems sustainable. In a given cell in Workbook 1 I have the following string: =VLOOKUP($D$2,'[SBE.XLSM]KPI 2017'!$A$9:$AC$20,COLUMN(B$9:B$19),FALSE) Both filename and sheetname should be a variable based on...
  3. A

    Is there an OFFSET style formula that works when the Data Source is not open?

    I've attached an example of the file I'm working on. I would like to keep the data in a separate file. But, offset formulas don't work if the data source is not open on your computer. I'm using the offset formula because I need to use both Row and Column references to find the data I need in...
  4. M

    From XML data import in Macintosh excel

    HiI was use an external web link in my windows excel to download latest changes in stock through:Data>From Other Sources>From XML Data ImportAnd The link is :http://members.tsetmc.com/tsev2/excel/MarketWatchPlus.aspx?d=0Does anyone has any idea that how can i use this link in Macintosh excel...
  5. M

    Use VBA to Import Data into Excel from MS Project 2013

    I am creating a dashboard in excel to display the status of many projects managed separately in MS Project. I would like to automatically import column headers and data from MS Project directly into a specified sheet within the dashboard workbook each time it opens. Does anyone have experience...
  6. P

    Pivot table added column in external source

    Hi all, I have created a pivot table from external data source (xlsx table). Refresh with new records worked fine until I added one column to the external source. Now excel freezes when I refresh. When I inserted one column in the internal data source the pivot table would only add a new data...
  7. S

    Create Pivot in present sheet from data located in another closed workbook

    Hi, I have an issue regarding the code i wrote. I am trying to create in a specific cell of a specific sheet of the workbook from which the module is located a pivot table for which the data comes from another workbook which is closed. But I have an error when it come to the last three lines...
  8. S

    Updating existing PivotTables from external data (Ms Access)

    Dearest Excel Magicians, Wizards and Gods I have a report that was made some time ago (P&L report). It grew to 60mb at this point, and with all the pivots, caluclations etc - well, it got very obese, slow and lazy. I figured out, that I will move all the source data to MS Access database. But...
  9. I

    pivot tables linked to Access database showing errors on trying to connect to data source

    Hi, I have created a file containing a number of pivot tables which are all pulling data from queries in an Access database. It has been working really well since 2011 and is the source of 90% the required data for reports for our organisation. I have been adding new pivot tables over the...
  10. M

    Pivot Table Data Source - External to Internal

    Hi everyone, I've been searching to find a way of changing my pivot table data source from Access file to a local excel sheet (of same file). Is that anyhow possible? When I select "Change Data Source" From PivotTable Tools / Options, it only allows me to select the second option, "Use an...
  11. B

    Refresh Linked Data in a Protected Worksheet

    Hello all, I am new to this forum and hoping that you will be able to help me. I am working on putting together a data correlation for a work project, and am connecting to an external SQL data source. I have created several rather large equations to work on the same sheet where the external...
  12. H

    Links to non-existent workbook magically work

    I have a workbook, workbook A, with lots of cells that link to a source workbook, workbook B. I copied workbook A from my hard drive at work to do some stuff at home, but I did not copy workbook B. I can't figure out how, but when I open workbook A (at home), the links to workbook B appear to...
  13. M

    External data source

    Can I use skydrive or other cloud services to store data that I want to use as an External Data Source?
  14. X

    Another Text to Formula Question

    Hi guys, trying to get the following string to be calculated as a formular; "'W:\....\Timesheets\[Some Ones_Timesheet.xls]We" & TEXT($I$2, "DDMMYY")& "'!E$15" Triyed Evaluate() as below but it comes back with ref error Function Eval(s As String) Eval = Evaluate(s) End Function
  15. A

    lookup from Excel into Access

    Hi all, I need some professional advice. I'm new to VBA and have very limited knowledge. But I need to create a macro that will automate some information me. See below for my problem/situation. I have multiple accounts that have different product codes on there such as… Act 1. Prod Code...
  16. K

    Pivot Tables and External Data huge file size swell

    Hi there I'm using Excel 2007. I have the following problem. I have 5 large data sheets (over 400,000 records each) that I want to analyse using various different sheets utilizing pivot tables. I want to update the input sheets periodically, and then just have the pivot tables in the analysis...
  17. J

    Creating pivot table from text file in VBA

    Hi, I have this VBAwhich works fine for creating a pivot table from a sheet: Set rngData = Worksheets(gs_sheet).Cells(gl_head_row, 1).Resize(gl_last_row, gl_last_col) ActiveSheet.PivotTableWizard SourceType:=xlExternal, SourceData:= _ rngData...
  18. N

    Error in Pivot table with external database

    I am using MS Excel/Access 2007. Using insert pivot table option in the ribbon bar, in the "Create Pivot Table dialog", I am choosing the option external data source to connect to a query in my existing Access2007 database. In the DataLink properties dialog, I choose the default option and...
  19. Victtor

    external excel data macro

    I need to create a file that when I click on a combo button, this macro command will: 1. search in the specified folder 2. open a source file 3. copy the data it needs 4. paste the data into the original file 5. close the source file. I need to be able to name the file directory on the...
  20. A

    Interactive Calendar - 2 Files - Multiple Criteria

    Hello All, thanks in advance for your time. I am having one of those days where I just am having the worst time trying to wrap my head around completing this task. I've searched google and the forums to try and find someone with a similar question - but couldn't find anything. I basically...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top