I have a workbook that links to several others for daily data reports. When
I link a cell to the data workbook merged cell I get a #VALUE error in the
cell. The link reads ='[0227 Company 3.xls]Day'!$J$5:$J$6. If I delete the
":$J$6 " portion of the link it works fine. How can I fix this? It's taking
twice as long to set up my links when I have to remove that portion for each
hour of each day. Prior to updating to 2007 I didn't have this problem.
HELP?!?!?

If you merge J5 and J6 you get one cell which is now J5

Refer to that cell only.


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 08:21:03 -0800, Skirk
wrote:

I have a workbook that links to several others for daily data reports. When
I link a cell to the data workbook merged cell I get a #VALUE error in the
cell. The link reads ='[0227 Company 3.xls]Day'!$J$5:$J$6. If I delete the
":$J$6 " portion of the link it works fine. How can I fix this? It's taking
twice as long to set up my links when I have to remove that portion for each
hour of each day. Prior to updating to 2007 I didn't have this problem.
HELP?!?!?

The cell is merged. When I select that cell it's name is J5. When I set the
link it call is J5:J6


"Gord Dibben" wrote:

If you merge J5 and J6 you get one cell which is now J5

Refer to that cell only.


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 08:21:03 -0800, Skirk
wrote:

I have a workbook that links to several others for daily data reports. When
I link a cell to the data workbook merged cell I get a #VALUE error in the
cell. The link reads ='[0227 Company 3.xls]Day'!$J$5:$J$6. If I delete the
":$J$6 " portion of the link it works fine. How can I fix this? It's taking
twice as long to set up my links when I have to remove that portion for each
hour of each day. Prior to updating to 2007 I didn't have this problem.
HELP?!?!?

.