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