After locating the EXPTOOWS file double click it and it will open a new Excel 2007 window. (1) Press ALT + F11 on your keyboard (2) then in the new Excel 2007 window minimize the first screen that opens and go to the code view.
(3) As highlighted in the screenshot then use the Find function to search for lVer = Application.SharePoint – depending on when you installed Excel 2007 and what patch level you're on, the code that is displayed next may be different. (4) If there is no line below "lVer = Application.SharePoint….." add a new line that reads lVer = 2 after that (5) save and close Excel. Retry the operation with your SharePoint site. If it still doesn't work try replacing what you just did with lVer = 3 and saving the file and rebooting your computer.