Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to eliminate E-mail "To" & "CC" boxes at top of Excel Sheet | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
how do I eliminate leading "0s" in an alpha numeric cell | Excel Discussion (Misc queries) | |||
Embedded status lines should eliminate annoying popup "OK"windows | Setting up and Configuration of Excel | |||
Excel should let me eliminate "duplicate records" in a column | Excel Discussion (Misc queries) |