Change the formulas to values in the cells/worksheets where you don't want the
formulas to update.

Select the range to fix
Edit|copy
edit|paste special|values

Is one way of doing it.

raisingcain wrote:

I use Excel 2002. I have a workbook where I enter data throughout the year
in one of the worksheets. There are 52 other worksheets, representing each
week of the year (with a beginning date and end date for each week.) Based
on formulas back to the €˜entry worksheet, data in the €˜weekly worksheets
change. I want the data in the worksheets representing weeks that have
already passed to not change, becoming historical records for those past
weeks, even though subsequent changes will be made in the €˜entry worksheet
and thus change the results in €˜future weeks.

Any ideas

--
raisingcain

--

Dave Peterson