Saving a file that you do not want to update the links to other fi
 

I have a summary report file that is linked to other files that I update the
info each week. I give the summary file a new name each week(basically the
week ending date).When I save the summary report and open it up after the
second week instead of keeping the original info it keeps updating with the
most current info. How can I make the summary report file stop updating and
just keep the info that it was saved with originaly for that week only.

Saving a file that you do not want to update the links to other fi
 

EditLinks

Break the links which converts the formulas to values then save.


Gord Dibben MS Excel MVP


On Wed, 9 Jul 2008 17:04:01 -0700, Derric
wrote:

I have a summary report file that is linked to other files that I update the
info each week. I give the summary file a new name each week(basically the
week ending date).When I save the summary report and open it up after the
second week instead of keeping the original info it keeps updating with the
most current info. How can I make the summary report file stop updating and
just keep the info that it was saved with originaly for that week only.