+ Reply to Thread
Results 1 to 2 of 2

Data tables to run IRRs on external data sources

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    London, UK
    MS-Off Ver
    Office 365 ProPlus
    Posts
    18

    Data tables to run IRRs on external data sources

    So the short question - do data tables still work if it would involve recalculating IRRs from external data?

    I'm using a data table to swap out external references used by the worksheet to generate a range of different values. Example attached to illustrate the structure (obviously ignore ref errors). While the approach works fine for simple calculations, I get unusual results for IRRs, some of which are correct, most are not. Its almost like the data table function only runs through a limited number of cycles, similar to iterative calculation, before showing an incomplete result (it does return values, normally negative and varying in size - its definitely calculating something!).

    I thought I'd found an efficient solution for dragging in large numbers of datasets (bear in mind I'm using more than 200 external sources), running various calculations, and then tabulating them. But if I can't get IRR to function, I'll need to do a full rethink.

    I'd welcome feedback on this problem!

    Also, I know this task requires something more powerful than Excel - that's a longer term project!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-02-2013
    Location
    London, UK
    MS-Off Ver
    Office 365 ProPlus
    Posts
    18

    Re: Data tables to run IRRs on external data sources

    My bad, there was a data table referencing issue with my original workbook, this function does indeed work!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] help on pivot tables using external data sources
    By Tewari in forum Excel General
    Replies: 2
    Last Post: 07-14-2020, 11:06 AM
  2. Replies: 0
    Last Post: 08-24-2017, 11:08 AM
  3. Update multiple pivots tables with external data sources at once
    By ayalami79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2013, 11:53 AM
  4. External Data Sources Dialog Box
    By sbnjac80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2009, 10:53 AM
  5. Issues retrieving data from external sources
    By jschell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2009, 09:09 AM
  6. external data from multiple sources
    By lou sanderson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2005, 03:06 PM
  7. [SOLVED] Why can't I edit my external data sources?
    By jcoburn in forum Excel General
    Replies: 0
    Last Post: 03-11-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1