View Single Post
  #1   Report Post  
Dirk Franke
 
Posts: n/a
Default Missing Reference in Excel 2003

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