software

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

nwexcelsolutions.com
gt; wrote in message oups.com...
gt;I have a spreadsheet that uses Morefunc to update values from about 30
gt; different spreadsheets on my computer. I need to email this
gt; spreadsheet to someone who will not have access to these individual
gt; files. I've already got the function set to volatile=false, but when
gt; this other user opens up the file, everything is blank. Is there a way
gt; to retain the last value if the file can't be found to update?
gt;
Or include morefunc in the workbook you distribute by means of:

Tools|Morefunc|Include Morefunc in the Workbook

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

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?Peoquot;Aladin Akyurekquot; gt; wrote in message
...
gt; Or include morefunc in the workbook you distribute by means of:
gt;
gt; Tools|Morefunc|Include Morefunc in the Workbook
gt;
gt; Peo Sjoblom wrote:
gt;gt; Make a copy of the workbook and paste all formulas as values and send
gt;gt; that copy
gt;gt;
gt; Copy/pasting values would work, but isn't really the optimal solution
gt; since its not 100% automated.

You can try this add-in
www.rondebruin.nl/mail/add-in.htm
--
Regards Ron de Bruin
www.rondebruin.nlgt; wrote in message oups.com...
gt; I've included morefunc in the workbook, but the problem is that this
gt; user cannot access the files that indirect.ext is linking to.
gt;
gt; Copy/pasting values would work, but isn't really the optimal solution
gt; since its not 100% automated.
gt;
That's correct, the linked workbooks will not be available.