I just got on data analysis using the “data sheet" function available under "what-if analysis". And it did not work<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
I followed all steps of the book (Excel bible 2007), for one cell change format for the loan amortization table, but all I got was a rows and columns of zeroes.<o></o>
<o> </o>
Please can someone explain to me in detail how the data sheet works and what is the “magic required" i.e. what and how to put formulas, if any required to be put. <o></o>
<o> </o>
fficeffice" /><o></o><o
> </o>I followed all steps of the book (Excel bible 2007), for one cell change format for the loan amortization table, but all I got was a rows and columns of zeroes.<o
></o><o
> </o>Please can someone explain to me in detail how the data sheet works and what is the “magic required" i.e. what and how to put formulas, if any required to be put. <o
></o><o
> </o>
