Are you meaning, that when you change some value in your table, then all comments are recalculated? This is an Excel feature. When you have automatic calculation on, then any change in any cell in any open workbook forces all formulas in all open workbooks to be recalculated. To check this, type something into any cell outside your table - you see that all comments are renewed.
You can set formula calculation to manual, but it doesn't help anyway - then no comments are recalculated at all, even the one for which you changed data. And manual calculation through F9 recalculates all comments again.
The only easy way to get random comments which don't change later, is through VBA procedure. You have to write the procedure, which has to check the active cell, to dermine, is this cell the one where a comment belongs, to read all nessessary parameters from your table, to calculate a random comment, and then to write it into active cell.
Not easy (a lot of manual work) way: have a separate sheet/workbook to calculate comments, and then copy-paste them into your table.
|