Cell references not working

[cuetzpalin]

Hello,

I have a hidden worksheet that I reference on a visible worksheet. I'm able to successfully reference some cells from the hidden worksheet, but I'm having trouble with others. I triple-checked my syntax and it looks good. I even used the same reference as in the cells that are working correctly and still shows the formula in the cell as oppose to the value from the referenced worksheet.

Any ideas?

Thank you!

 

[cuetzpalin]

Here's an example of a formula that works in one cell but not another:

=Details!C2

This for MS Excel 2003.

Is there some kind of special formatting I need to do? Just don't get why it merges fine one some cells but the same formula won't work on another cell.

Thanks in advance.

 

[SkipVought]

Hi,

I triple-checked my syntax and it looks good.

How did your "triple-check"?

Do you have MERGED CELLS on your hidden sheet?

The foolproof way to assign range reference is to point 'n' click

Reference do not lie!

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[cuetzpalin]

Thanks for the point n click tip. I tried that by first typing an "=" sign in the destination cell then I went over to the other worksheet and clicked it and hit enter. It hightlighted as in it recognized the reference but it doesn't stick.

Is there any known bugs?

Please advise.

Thanks again!

 

[SkipVought]

If you wish to send, I'll look

skipandmary1017

at

mindspring

dot

com

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]