Workbook links
 

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?!?!?

Workbook links
 

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?!?!?

Workbook links
 

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?!?!?

.