Link to external worksheet merged cell returns a #VALUE
 

='[10-11-2009 Group B.xls]Day'!$J$5:$J$6 It is linking the range of merged
cells instead of just one cell. I've been doing this for a year and never
had a problem. No recent upgrade or formatting of files. HELP????

Link to external worksheet merged cell returns a #VALUE
 

Just link to the first cell in the merger:

='C:\Temp\[visit me.xls]Sheet1'!$A$2

--
Gary''s Student - gsnu200906


"Skirk" wrote:

='[10-11-2009 Group B.xls]Day'!$J$5:$J$6 It is linking the range of merged
cells instead of just one cell. I've been doing this for a year and never
had a problem. No recent upgrade or formatting of files. HELP????