+ Reply to Thread
Results 1 to 7 of 7

Using Morefunc - Indirect.Ext when Offline

  1. #1
    John.Forr@gmail.com
    Guest

    Using Morefunc - Indirect.Ext when Offline

    I have a spreadsheet that uses Morefunc to update values from about 30
    different spreadsheets on my computer. I need to email this
    spreadsheet to someone who will not have access to these individual
    files. I've already got the function set to volatile=false, but when
    this other user opens up the file, everything is blank. Is there a way
    to retain the last value if the file can't be found to update?


  2. #2
    Peo Sjoblom
    Guest

    Re: Using Morefunc - Indirect.Ext when Offline

    Make a copy of the workbook and paste all formulas as values and send that
    copy

    --

    Regards,

    Peo Sjoblom

    http://nwexcelsolutions.com



    <John.Forr@gmail.com> wrote in message
    news:1146496575.485511.310740@y43g2000cwc.googlegroups.com...
    >I have a spreadsheet that uses Morefunc to update values from about 30
    > different spreadsheets on my computer. I need to email this
    > spreadsheet to someone who will not have access to these individual
    > files. I've already got the function set to volatile=false, but when
    > this other user opens up the file, everything is blank. Is there a way
    > to retain the last value if the file can't be found to update?
    >




  3. #3
    Aladin Akyurek
    Guest

    Re: Using Morefunc - Indirect.Ext when Offline

    Or include morefunc in the workbook you distribute by means of:

    Tools|Morefunc|Include Morefunc in the Workbook

    Peo Sjoblom wrote:
    > Make a copy of the workbook and paste all formulas as values and send that
    > copy
    >


  4. #4
    John.Forr@gmail.com
    Guest

    Re: Using Morefunc - Indirect.Ext when Offline

    I've included morefunc in the workbook, but the problem is that this
    user cannot access the files that indirect.ext is linking to.

    Copy/pasting values would work, but isn't really the optimal solution
    since its not 100% automated.


  5. #5
    Peo Sjoblom
    Guest

    Re: Using Morefunc - Indirect.Ext when Offline

    I also read it as if the linked workbooks were not available as well?


    Peo


    "Aladin Akyurek" <akyurek@xs4all.nl> wrote in message
    news:4456301e$0$31653$e4fe514c@news.xs4all.nl...
    > Or include morefunc in the workbook you distribute by means of:
    >
    > Tools|Morefunc|Include Morefunc in the Workbook
    >
    > Peo Sjoblom wrote:
    >> Make a copy of the workbook and paste all formulas as values and send
    >> that copy
    >>




  6. #6
    Ron de Bruin
    Guest

    Re: Using Morefunc - Indirect.Ext when Offline

    > Copy/pasting values would work, but isn't really the optimal solution
    > since its not 100% automated.


    You can try this add-in
    http://www.rondebruin.nl/mail/add-in.htm



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    <John.Forr@gmail.com> wrote in message news:1146500169.495520.264020@i39g2000cwa.googlegroups.com...
    > I've included morefunc in the workbook, but the problem is that this
    > user cannot access the files that indirect.ext is linking to.
    >
    > Copy/pasting values would work, but isn't really the optimal solution
    > since its not 100% automated.
    >




  7. #7
    John.Forr@gmail.com
    Guest

    Re: Using Morefunc - Indirect.Ext when Offline

    That's correct, the linked workbooks will not be available.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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