+ Reply to Thread
Results 1 to 2 of 2

Formula only works with referenced workbooks open

  1. #1
    Registered User
    Join Date
    Pacific Northwest
    MS-Off Ver
    Excel 20010 (Mac)

    Formula only works with referenced workbooks open

    First post.

    I have a rather involved Summary Workbook with formulas that use INDIRECT() to search individual workbook(s) (and specific worksheets) for data to bring in. Unfortunately, the formula only works if the referenced workbook(s) are open PRIOR TO the Summary Workbook being opened - even when I manually calculate. I would like the Summary Workbook to "find" the data in the other workbooks regardless of them being open or closed.

    All workbooks (including the Summary) are stored in the same folder.

    I am restricted from using the Trust Center Macro and Update functions due to Group Policy from our network.

    Any recommendations would be most appreciated.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    MS-Off Ver
    Excel 2010

    Re: Formula only works with referenced workbooks open

    There is a function called INDIRECT.EXT that can be used to reference closed source books. It is part of a free addin (Morefunc) that you can get here:


    BUT, I'm not sure if it is fully compatible with 2010 so do some research on that first.
    Last edited by Cutter; 05-19-2012 at 07:29 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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