Link to external worksheet merged cell returns a #VALUE

  • Thread starter Thread starter Skirk
  • Start date Start date
S

Skirk

='[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????
 
Just link to the first cell in the merger:

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