When choosing the option to add a custom error bar in Exel 2007 and trying to
set the range to a worksheet that does not contain the chart I receive an
error in Excel that closes down Excel.

The steps I perform a 1. Click on a bar in my chart 2. Click Layout 3.
Click the drop down for error bars 4. Click more error bar options... 5.
Choose custom and click specify value. 6. Click to set the range where this
is then displayed ={1}.

As soon as I change to the worksheet to set the range Excel errors out and
shuts down.

I have recreated this on more than one machine and the result is the same. I
have also seen other posting this same problem with no resolution.

Thanks