Thread: Link to external worksheet merged cell returns a #VALUE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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????
Reply With QuoteReply With Quote