View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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