Click the linked workbook that you want to update, and then click. In Microsoft Office Excel 2007, click the Data tab, and then click Edit Links in the Connections group. You may want to export the VBA code, using the procedure above, before deleting the VBA code. To update the links, follow these steps: In Microsoft Office Excel 2003 or in Microsoft Excel 2002, click Links on the Edit menu. Standard modules, user forms, and class modules will be removed, and code within the ThisWorkbook module and the sheet modules will be deleted. In this way we can disable automatic update of links. Click on Ok button will ensure that links will not get updated even if the Source file gets updated. Scroll down till you find When calculating this workbook Uncheck the first checkbox i.e. You should use this procedure with care, as it will permanently delete the code. From Excel Options window select Advanced. The procedure below will delete all the VBA code in a project. NOTE THE WARNING in there as it will permanently delete the code. Have you deleted the modules as well, as any module whtheer empty or not will trigger the message.įailing that, the following is from Chip Pearson's website, and will delete all VBA in a projects.

Disable links in excel 2003 spreadsheet