I have a .xlsm file using macros and pivot tables with an external datasource (.udl). I need to make it useable in office 2003, so what I did was to save it as .xls and since it uses, udl, I should have no problems in changing datasources. However, when I open the files, all the macros (drop downs of the pivot tables) are all disabled. When I double click these macros, I get the error saying that the pivot tables are created in a later version and that I should click ok and then open the file using the version in which it has been created. Is there anyway for me to enable the macros? I tried toggling the macro security but to no avail. I hope there's another way beside redoing the report in 2003. Thanks!