break links crashes Excel 2002

[EDS]

Stephen Bullen wrote:
"If you don't have many embedded objects (charts, controls etc) and no
VBA code, you could try saving as XML and re-opening."

Thanks Stephen. That would be useful to view the raw data but not fo
this. The format of the workbook cannot change. It is used fo
purchase orders so it must look the same to all people all the time.
The problem arises when a copy of it is used to create a purchase orde
and someone opens the order but does not have access to the origina
(which is nearly always the case). I want them to see the values.
This is what this "break link" command is intended to do. The proble
is that it crashes Excel when we try it. Excel gives no indication o
why it crashed; at least none that I can see in Event Viewer. We nee
to be able to break the links and save the values so that the perso
looking at it doesn't have a lot of worthless "REF!" in cells tha
should have meaningful data

 

[keepITcool]

could it be a damaged name object?
use Name Manager (http://www.bmsltd.ie/MVP/Default.htm)
to check for invalid external names.

else zip and email and I'll have a look.