external data

  1. Y

    Generating REAL TIME (no 15 min delay) stock prices in Excel

    Hi there, I am looking for a wizard to help me out on this one. I've created a rather advanced Excel workbook that tracks stocks (analyses, gives alerts, atc). The only thing missing is real time stock prices. I have tried many many things to get real time stockprices in my spreadsheet (power...
  2. V

    Getting external data from Dynamic Path and Closed Files

    Hello, I'm trying to get external data from a number of different excel files across different Locations, WITHOUT needing to open the files. I want to aggregate all data from one year (on different Closed workbooks) into a single sheet (per store) on the Open Workbook . The Closed woorkbooks...
  3. C

    How to refresh data from external source

    I currently have a link on a spreadsheet that will open the source file for when data may need refreshing. How do I get the data to refresh by clicking this link without the source file opening up?
  4. J

    VBA code to Modify Formula using new External Workbook Hyperlink

    Hi, I have a Workbook that serves as an aggregation of data from several other external workbooks (same file directory). The workbooks being referenced are all uniform, so the specific sheet and cell reference is always the same in a column with the only thing changing being the workbook name...
  5. P

    How to download this data in one excel file but in multiple sheets ?

    I am trying to pull Historical data for derivatives into excel and keep running into a wall. https://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm This is the link from where I wish to download the data into excel. I can pull the CSV file individually from the...
  6. O

    !! Data Model Lost Connection to Workbook !! Time Sensitive Request !!

    Normally I search a long time before posting but I have to get to a meeting and if I cannot get this answered now (4pm EST on a Friday afternoon), I cannot finish work planned for this weekend. I would DEEPLY appreciate any help! The research I've found looks like there is no solution from...
  7. T

    Excel Browsing a folder and Automating Data Entry using a default template

    I been reading up codes available on the net from various sources and have debug with self-taught programming to make it work but I'm having difficulty proceeding on. As you can see, it comes from a source. Browsing a folder & reading the files works fine with the code, I need to copy values...
  8. D

    External Data with additional columns

    Dear all, Recently I have come across a problem regarding the use of pulling external data from XML files to Excel 2010. I work for a very small hotel. The hotel database we are using is very poor by any standard, so we cannot but make up its deficiencies by pulling some of its data to Excel...
  9. S

    External Data From Other Sources (From Microsoft Enquiry) will not display data with different formats

    I have a mirrored table so I can show selected data from a larger table. Problem is, one of the columns contains serial numbers which are a combination of number only and number and text values (i.e. 1208667 and 1029FB6). When I refresh my mirrored table, only the number values appear, not the...
  10. M

    Refreshable Data Connection from Web to Excel TABLE

    The end goal is to have an Excel Table with a refreshable data connection to a web table. The reason to have an Excel Table is to use that Table as a reference point on other sheets, to perform calculations on other sheets, and to create summaries on other sheets. All of this is made much...
  11. R

    COUNTIFS in External Sheet, Over multiple sheets

    Hello. I'm hoping someone will be able to help me with this one, I'm looking to search an external workbook for any occurrences between 2 dates. The dates are obtained by looking up the dates from a business calendar which is in a separate sheet. That is retrieved by the HLOOKP function I've...
  12. C

    Error Opening Excel File with External Data from Access

    Hi everyone, I did a few searches on this but didn't find anything, so hopefully you can give me a hand. I have an Excel file that is pulling data in from Access queries and when I open the file, I don't see any issues. The links seem to work and if I change the data going into the query, I...
  13. T

    External Data from PDF with many tables.

    Hello, is there a simple way (or not) to get data results from a table within a PDF that has more than one table in it?
  14. J

    VBA code causes excel to crash when saved and/or (file has external links)

    Hey guys! Thank you for the immense help you have already given by being so active. I have an excel file with some VBA code (fairly new to the (for me) more advanced stuff). The code is working fine, and was working when I was creating it. Now when I make a change in the file, save, close...
  15. J

    Referencing Cell Values in Another Worksheet

    Hi, I have data spread across several worksheets. When I change the data in the Master spreadsheet I would like it to update data in the other worksheets. For example, when I update a sale in the Master spreadsheet from Pending to Sold, I would like to also update in the relative sheets. When...
  16. B

    External Links not auto-updating when Source File is OPEN

    I have a very odd occurrence happening. My linked data is not updating when my source file is open. I have a central workbook that has links to about two-dozen source workbooks. The links work properly when I open the file. However, if I open both the Master workbook and one of the source...
  17. K

    Creating dropdown list from external source

    Hi! I've created a sheet that will be used by our company for creating requests for purchase orders. Some of the information required to be chosen via a drop down list will need to be updated periodically. I would like to update the information, without having to always send a new form out. I...
  18. D

    Cell variable in external external link (hlookup fuction)

    Hi all, I am dealing with a huge amount of data on google and forums, but can't seem to place it all together. 1. I need concatenation for this, since from what I read INDIRECT() does can't open closed excel files. 2. I can't use MOREFUNC | Ashish Mathur's Blog (morefunc), cause it's on the...
  19. C

    Link External Data into Excel Through VBA

    I want to set a macro in Excel workbook and run/follow following steps. After click on Shape1 (Rectangle Shape Inserted and macro assign on click) Insert New Sheet with Name : BOQ Remove if any table exist with name : BOQTbl in open workbook Remove if any Existing Connection name ...
  20. B

    External Data Dropping Cells with Alphanumeric Data

    Hello. I'm working with a workbook that connects to an external data source (table in excel) when opened. Most of the data from the external table consists of 6 numerical digits. However, some cells have alphanumeric cells which is the 6 digits followed by a single letter. The data connection...

Some videos you may like

This Week's Hot Topics

Top