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

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

Bob Phillips wrote:
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.

Hallo Bob,

thanks for your reply. But i want to solve this #REF error.
Is there a way to say excel that it should not calculate?
I want to know to with cell the missing reference points.

Do you have any idea?

Thanks a lot

Dirk

Dirk,

There are many ways. You can either

track down the source errors and correct them

or you can trap the errors where they get used, for instance in G492, if the
formula is =VLOOKUP(.... you could use an error trap that says
=IF(ISERROR(VLOOKUP(...),"",VLOOKUP(..., etc although you will probably need
the German function names.

--

HTH

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


"Dirk Franke" wrote in message
...
Bob Phillips wrote:
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.

Hallo Bob,

thanks for your reply. But i want to solve this #REF error.
Is there a way to say excel that it should not calculate?
I want to know to with cell the missing reference points.

Do you have any idea?

Thanks a lot

Dirk

Bob Phillips wrote:
Dirk,

There are many ways. You can either

track down the source errors and correct them

or you can trap the errors where they get used, for instance in G492, if the
formula is =VLOOKUP(.... you could use an error trap that says
=IF(ISERROR(VLOOKUP(...),"",VLOOKUP(..., etc although you will probably need
the German function names.

Hello Bob,

thanks for your reply. I am not familiar with tracking down errors in
excel. Could you give me an example?

Thanks Dirk

It's just a case of follow the trail Dirk.

Look at a cell, if it has a reference to another cell or cells, go to each
of these in turn and see which one is generating the error.

--

HTH

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


"Dirk Franke" wrote in message
...
Bob Phillips wrote:
Dirk,

There are many ways. You can either

track down the source errors and correct them

or you can trap the errors where they get used, for instance in G492, if
the
formula is =VLOOKUP(.... you could use an error trap that says
=IF(ISERROR(VLOOKUP(...),"",VLOOKUP(..., etc although you will probably
need
the German function names.

Hello Bob,

thanks for your reply. I am not familiar with tracking down errors in
excel. Could you give me an example?

Thanks Dirk