when copying from one spreadsheet to another I get "#VALUE!" error,how can I eliminate it?
 

I have a spreadsheet that is very large and contains a bunch of macros
and formulas. When I am done, instead of sending the entire worksheet
to a colleague for review I cut and past the only sheet they need to
see into another spreadsheet. When they open it they are prompted to
"this workbook contains links to other data sources". No matter if
they click yes or no they will get "#VALUE!" in many of the boxes that
should contain data.

Is there a way for me to stop that from happening?

when copying from one spreadsheet to another I get "#VALUE!" error, how can I eliminate it?
 

Convert the formulas to values

For code and a add-in to send a single sheet see
http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Joe" wrote in message ...
I have a spreadsheet that is very large and contains a bunch of macros
and formulas. When I am done, instead of sending the entire worksheet
to a colleague for review I cut and past the only sheet they need to
see into another spreadsheet. When they open it they are prompted to
"this workbook contains links to other data sources". No matter if
they click yes or no they will get "#VALUE!" in many of the boxes that
should contain data.

Is there a way for me to stop that from happening?

when copying from one spreadsheet to another I get "#VALUE!" error,how can I eliminate it?
 

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Each recipient would have to make this same change.

Joe wrote:

I have a spreadsheet that is very large and contains a bunch of macros
and formulas. When I am done, instead of sending the entire worksheet
to a colleague for review I cut and past the only sheet they need to
see into another spreadsheet. When they open it they are prompted to
"this workbook contains links to other data sources". No matter if
they click yes or no they will get "#VALUE!" in many of the boxes that
should contain data.

Is there a way for me to stop that from happening?

--

Dave Peterson

when copying from one spreadsheet to another I get "#VALUE!" error, how can I eliminate it?
 

I cut and past the only sheet they need to
see into another spreadsheet.

Select the entire sheet you have copied then:

-Copy
-PasteSpecialValues

--
HTH,
George


"Joe" wrote in message
...
I have a spreadsheet that is very large and contains a bunch of macros
and formulas. When I am done, instead of sending the entire worksheet
to a colleague for review I cut and past the only sheet they need to
see into another spreadsheet. When they open it they are prompted to
"this workbook contains links to other data sources". No matter if
they click yes or no they will get "#VALUE!" in many of the boxes that
should contain data.

Is there a way for me to stop that from happening?