Dirk,

This sounds like a German workbook which has a #REF error. Take a look at
cell G492 and H492 and see if they are in error. If so, trace the error
down.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dirk Franke" wrote in message
...
Hello,

i have an excel 2003 sheet with some calculations.
More over i have a column where i display the
contents of some cells e.g.
=B500&$G492&$H492
That works fine but sometimes i get this

=B500&#BEZUG!&#BEZUG!

I dont know the problem.
How can i resolve #BEZUG! to the value excel wants to use?

Thanks Dirk