Results 1 to 9 of 9

Dynamic Sumproduct using external workbook without it being open

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2017
    Location
    Nottingham, England
    MS-Off Ver
    2013
    Posts
    13

    Dynamic Sumproduct using external workbook without it being open

    Hello

    I have a sumproduct formula that dynamically checks for headers of data to compare if they have certain criteria.

    Now this formula works but now I'm trying to make it look for data on a external workbook without it being open, so my customers can just replace the raw data with new data, so I have read a few website on how to make it read external workbook but it displaying #Value and when I close the raw data workbook it keeps showing unable to read file.

    Any help on this would be great.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIF or SUMPRODUCT on External Workbook w/ Wildcards.
    By k64 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-31-2016, 10:03 AM
  2. [SOLVED] Sumproduct formula linking to external workbook works in one file, but not another
    By needmorejam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2015, 05:05 PM
  3. External Workbook Link with Dynamic Cell Reference
    By mst3kr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2014, 10:24 PM
  4. External Workbook Link with Dynamic Name
    By AdamParker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2009, 01:26 PM
  5. open external workbook keep hidden
    By cereldine in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2006, 07:35 AM
  6. [SOLVED] Dynamic External Workbook reference
    By Co-op Bank in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2005, 07:10 PM
  7. Dynamic External Workbook Formula
    By Co-op Bank in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2005, 01:10 PM

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