Hi Bonnie,
If you are having trouble with formulas or just want to document them
I find them a lot more useful if they are included on the same printed
page or displayed in another cell somewhere, whether it be an
adjacent column simply one representative formula. See
GetFormula and GetFormulaD user defined functions in

Show FORMULA or FORMAT of another cell
. http://www.mvps.org/dmcritchie/excel/formula.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bonnie" wrote in message ...
Hello all! Using E02 on XP. Have linked cells in OutFile.xls 'reading' data
from InFile.xls. Rather than handwrite my cell mapping, how can I print the
linked cells or the formulas?

Example: InFile has:

A B C
1 10.45 9.32 3.25
2 9.87 5.98 5.32
3 12.87 10.11 7.42

OutFile has:

D L
V
10 ='S:\[InFile.xls]P4'!A1 ='S:\[InFile.xls]P4'!B1
='S:\[InFile.xls]P4'!C1
22 ='S:\[InFile.xls]P4'!A2 ='S:\[InFile.xls]P4'!B2
='S:\[InFile.xls]P4'!C2
36 ='S:\[InFile.xls]P4'!A3 ='S:\[InFile.xls]P4'!B3
='S:\[InFile.xls]P4'!C3

Rather than print my InFile and resulting values from OutFile (showing row
and col numbers) and handwriting the mapping (=A1, =B2, etc.) I would like to
print the formulas as you can see above. Hope I'm explaining this well
enough so anyone reading can understand.

Thanks in advance for any advice or help!!!
--
Bonnie