Will wrote:
I take your point, but presumably this would then mean that the estimating
workbook would not work as it would only contain those parameters which were
selected when it was initially sent?



It depends on how you have written your formulas.

If you have just brought individual parameters into cells in the estimating
workbook by links (e.g. =[clientparams.xls]Sheet1!CostPerPage ) then breaking
the link will put the relevant value into the cell.

If you have included references to the source workbook in a more complicated
formula (e.g. =NumberOfPages*[clientparams.xls]Sheet1!CostPerPage )
then you are correct, that formula will not continue to work when you change
NumberOfPages since the entire formula will be replaced by its current value.

You might therefore choose to have a MyCostPerPage cell in the estimating
workbook, containing =[clientparams.xls]Sheet1!CostPerPage and change your
formula to =NumberOfPages*MyCostPerPage .

As I said, the user will easily be able to determine what his parameters are,
given that the formulas can be seen, but at least he won't be plagued by
"update links?" questions when opening the workbook.




Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup