F4 will cycle you through the various types of references.

"globallinker" wrote:

i am linking cells in a workbook to another workbook. the link gives me the
$c$45 format which does not allow me to copy to other cells that are
contiguous.

how and where do you change the format so it gives you c45 as the reference
when linking?

thanks.