Link to external worksheet merged cell returns a #VALUE

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

Gary''s Student

Just link to the first cell in the merger:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I reference a value to consecutive merged cells 1
Format changes in a merged cell 2
datevalue returns #value 5
Workday function returns the wrong date when the duration is 5 day 5
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
Any way to sort rows of data with merged cells???? 0
Merged cell data tabulated in columns 4

Top