Your post is a little unclear. Are you trying to update cells in a closed
workbooK. If so check out this link...

http://www.dailydoseofexcel.com/arch...ing-workbooks/
--
HTH...

Jim Thomlinson


"Excel opens other files" wrote:

When doing calculations in Excel, using Visual Basic, the excel file being
reference will automatically open. It should just update cells with the file
closed. Is there a setting for this? I have tried to uninstall office and
reinstall but it still does it.