I have a weekly summary report that is linked to several other spreadsheets
that I update weekly. I save the summary report each week with a new file
name (basically the week ending date). But when I open the file a couple of
weeks later the information for that specific week ending is purged and the
most current info is now in its place. How can I save a file and not allow it
to update cells that are linked to other files.