Hi Tom,
An alternative to show all of the formulas used would be a formatted list.:
Creating a List of Formulas (Tip 37) , John Walkenbach's site http://j-walk.com/ss/excel/tips/tip37.htm
Personally I find it much better to show some representative
working formulas right on the spreadsheet in another cell or
another column.. http://www.mvps.org/dmcritchie/excel/excel.htm
GetFormula(D14)
personal.xls!GetFormulaD(D14) -- when function in another workbook