It sounds like you are having trouble with the automatic updates of links between files in Excel 2007. Here's how you can set up the process to choose whether to update or not:

1. Open Excel and click on the Office button in the top left corner.
2. Click on Excel Options at the bottom of the menu.
3. Click on Trust Center in the left-hand menu.
4. Click on Trust Center Settings in the main window.
5. Click on External Content in the left-hand menu.
6. Under Security settings for Workbook Links, select the option that says "Prompt user on automatic update of links".
7. Click OK to save the changes and close the Trust Center.
8. Save and close the file with links to another file.

Now, when you open the file with links to another file, you should see a security warning in the message bar. Click on the warning to see your options. You should see a button that says "Enable Content". Click on this button to update the links. If you don't want to update the links, simply click on the X in the top right corner of the warning to close it.