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
Merged cell data tabulated in columns 4
Advanced Filter used with merged cells? 1
Linking Merged Cells 2
how do i link merged cells to a merged cell in another worksheet. 3
Summing from multiple wksts - incomprehensible #VALUE error 7
pasting a value to a merged cell 1

Top