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?

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



<[email protected]> wrote in message
news:[email protected]...
>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?
>

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
>

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.

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


Peo


"Aladin Akyurek" <[email protected]> wrote in message
news:[email protected]...
> 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
>>

> 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


<[email protected]> wrote in message news:[email protected]...
> 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.
>

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