Thanks very much for the information. I think I'll do that.

"LenB" wrote:

Maybe this is what you mean. For the people receiving the file, they
could uncheck the setting for "Ask to Update Automatic Links" on the
edit tab of Tools - Options. Of course that will affect all
spreadsheets they open, not just yours.
Maybe you didn't understand what I first suggested, so here is more
detail. Before you send the file, save a new copy (if you need to keep
your copy with the links). Select All (Ctrl+a), then Copy (Ctrl+c),
then paste special - values (Alt e s v). Takes less than 2 seconds.
There will now be no links (or formulas) in this copy of the file.
Formatting will stay the same. Send it and they will be happy! Good
luck. If you want to automate it, record a macro and assign to a
button. If you are into writing macros, I think links are in a
collection so a loop to go thru them all and replace each link with its
value could be done.

Len

Leslie wrote:
I was hoping to figure out an automated way. If "they" don't have the main
workbook I would like to program something that says show or permit values
(not formulas) and keep formatting and don't look for updates or show that
screen that asks them do they want to update.