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



wrote in message
oups.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?

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" wrote in message
...
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


wrote in message oups.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.

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