I am using Office 2010, i developed a small macro(in Office 2007) to merge worksheets content in a single worksheet. While trying to run the macro in 2010 a pop up comes in a sheet, which is requiring automatic updates option. So it blocks the macros to work properly. Is there any way to disable the automatic update option in Office 2010.
Note : Once i open the excel file it shows that The work book contain links to the data sources