Problem linking to a cell with a date.

[Tech.Zoan]

I want to link a summary spreadsheet with multiple project
spreadsheets and one of the cells i'm linking to is a cell with the
"TODAY()" function but it is actually two cells that I have merged
together... so say D4 and D5.

So when I do the linking, what gets copied into my summary spreadsheet
looks something like this... ='[New Project.xls]Summary'!$D$4:$D$5

That generates a #VALUE! error. If I remove the ":$D$5" part
manually, then the error disappears and the link is established fine.

For esthetic reasons, I want to keep the date in the merged format.
Any way I can save having to go and remove the last part of the link?

TIA

 

[Dave Peterson]

I use xl2003.

I tried copying a couple of merged cells and then did an
edit|paste special|paste link
and the formula pointed at the left most cell (just a single cell).

I tried typing = in the receiving cell and then traversing to the merged cell
and created the formula by clicking on it and hitting enter.

That formula also used just a single cell.

I can't duplicate how you're creating the link that would put both cells in the
formula.

Maybe you can give more details including how you created the link.

I want to link a summary spreadsheet with multiple project
spreadsheets and one of the cells i'm linking to is a cell with the
"TODAY()" function but it is actually two cells that I have merged
together... so say D4 and D5.

So when I do the linking, what gets copied into my summary spreadsheet
looks something like this... ='[New Project.xls]Summary'!$D$4:$D$5

That generates a #VALUE! error. If I remove the ":$D$5" part
manually, then the error disappears and the link is established fine.

For esthetic reasons, I want to keep the date in the merged format.
Any way I can save having to go and remove the last part of the link?

TIA