Problem linking to a cell with a date.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tech.Zoan - 15 Feb 2008 13:16 GMT

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

Reply to this Message

Dave Peterson - 15 Feb 2008 15:17 GMT

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
[quoted text clipped - 11 lines]
>
> TIA

Signature

Dave Peterson

Reply to this Message