Referencing merged cells

  • Thread starter Thread starter Bill Allen
  • Start date Start date
B

Bill Allen

I'm having trouble referencing a merged cell in another workbook.

Say I merge cells A1 to C1 in workbook 1. When I make this the active cell,
the Name Box says "A1". When I go to another workbook (say, workbook 2), go
to cell B1, type "=" and then go to the merged cell and select it, I get
'workbook1'!$A$1:$C$1 as the formula and, of course, the "#VALUE" error.

I've successfully tried typing "=sum(" without the quotes hen clicking on
the contents of the cell and then adding the ")" and it works O.K. but there
should be an easier way.

Is there?

TIA,

Bill

BTW, I'm using Excel 2002.
 
Are you sure your merged cells were a1:c1?

I just tried that with xl2002 and it worked fine for me:

=[book1.xls]Sheet1!$A$1

(and a1:c1 was/were merged!)
 
Argh!

It worked for me, too. Honest! I have run into this problem LOTS of times on
a REGULAR basis. Could it be a problem when there are LOTS of merged cells
in the sheet?

I can't believe it's a memory or box issue. I should have plenty of memory
and I'm running a P4.

But, if you can't replicate the problem, I can't expect you to provide any
suggestions.

Mind if I send you a couple of files privately?

Bill

Dave Peterson said:
Are you sure your merged cells were a1:c1?

I just tried that with xl2002 and it worked fine for me:

=[book1.xls]Sheet1!$A$1

(and a1:c1 was/were merged!)

Bill said:
I'm having trouble referencing a merged cell in another workbook.

Say I merge cells A1 to C1 in workbook 1. When I make this the active cell,
the Name Box says "A1". When I go to another workbook (say, workbook 2), go
to cell B1, type "=" and then go to the merged cell and select it, I get
'workbook1'!$A$1:$C$1 as the formula and, of course, the "#VALUE" error.

I've successfully tried typing "=sum(" without the quotes hen clicking on
the contents of the cell and then adding the ")" and it works O.K. but there
should be an easier way.

Is there?

TIA,

Bill

BTW, I'm using Excel 2002.
Click to expand...
Click to expand...
 
If you skinny them down, ok.

But I won't be able to look at them until tomorrow evening.

You might do better to post more info in the newsgroup.



Bill said:
Argh!

It worked for me, too. Honest! I have run into this problem LOTS of times on
a REGULAR basis. Could it be a problem when there are LOTS of merged cells
in the sheet?

I can't believe it's a memory or box issue. I should have plenty of memory
and I'm running a P4.

But, if you can't replicate the problem, I can't expect you to provide any
suggestions.

Mind if I send you a couple of files privately?

Bill

Dave Peterson said:
Are you sure your merged cells were a1:c1?

I just tried that with xl2002 and it worked fine for me:

=[book1.xls]Sheet1!$A$1

(and a1:c1 was/were merged!)

Bill said:
I'm having trouble referencing a merged cell in another workbook.

Say I merge cells A1 to C1 in workbook 1. When I make this the active cell,
the Name Box says "A1". When I go to another workbook (say, workbook 2), go
to cell B1, type "=" and then go to the merged cell and select it, I get
'workbook1'!$A$1:$C$1 as the formula and, of course, the "#VALUE" error.

I've successfully tried typing "=sum(" without the quotes hen clicking on
the contents of the cell and then adding the ")" and it works O.K. but there
should be an easier way.

Is there?

TIA,

Bill

BTW, I'm using Excel 2002.
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the offer, Dave.

The issue is more aggravating than critical. When I come upon it again,
maybe I'll have a better example.

Regards,

Bill
Dave Peterson said:
If you skinny them down, ok.

But I won't be able to look at them until tomorrow evening.

You might do better to post more info in the newsgroup.



Bill said:
Argh!

It worked for me, too. Honest! I have run into this problem LOTS of times on
a REGULAR basis. Could it be a problem when there are LOTS of merged cells
in the sheet?

I can't believe it's a memory or box issue. I should have plenty of memory
and I'm running a P4.

But, if you can't replicate the problem, I can't expect you to provide any
suggestions.

Mind if I send you a couple of files privately?

Bill

Dave Peterson said:
Are you sure your merged cells were a1:c1?

I just tried that with xl2002 and it worked fine for me:

=[book1.xls]Sheet1!$A$1

(and a1:c1 was/were merged!)

Bill Allen wrote:

I'm having trouble referencing a merged cell in another workbook.

Say I merge cells A1 to C1 in workbook 1. When I make this the
Click to expand...
active
cell,
the Name Box says "A1". When I go to another workbook (say, workbook
Click to expand...
2),
go
to cell B1, type "=" and then go to the merged cell and select it, I get
'workbook1'!$A$1:$C$1 as the formula and, of course, the "#VALUE" error.

I've successfully tried typing "=sum(" without the quotes hen
Click to expand...
clicking
on
the contents of the cell and then adding the ")" and it works O.K.
Click to expand...
but
there
should be an easier way.

Is there?

TIA,

Bill

BTW, I'm using Excel 2002.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top