Have a summary spreadsheet based on another spreadsheet.
When I copy the links into the summary spreadsheet,
the contents of the cell isn't:
"c:\Exce\Data\[Payout.xls]Summary'!C12.xls"
-the summary worksheet sums the five
other worksheets.
the link is:
"(c:\Exce\Data\[Payout.xls]Sheet1'!C12+
c:\Exce\Data\[Payout.xls]Sheet2'!C12+
c:\Exce\Data\[Payout.xls]Sheet3'!C12+
c:\Exce\Data\[Payout.xls]Sheet4'!C12+
c:\Exce\Data\[Payout.xls]Sheet5'!C12)
This link can get veeeeeeeeeery long.

Why can't the link represent just
the one cell from the Summary sheet?
The values are correct, but I don't need
to know that the link is based on five
supporting worksheets within the
same spreadsheet.