Hi there! I'm sorry to hear that you're experiencing this issue with Excel. The "automation error" and "unspecified error" messages can be frustrating, but there are a few things you can try to resolve the issue.

1. Disable add-ins: Sometimes, add-ins can cause conflicts with Excel and result in errors. To disable add-ins, go to the "File" tab, click "Options," and then select "Add-ins." From there, you can manage your add-ins and disable any that you suspect may be causing the issue.
   
2. Clear Excel's cache: Excel stores temporary files in a cache, and sometimes these files can become corrupted and cause errors. To clear the cache, go to the "File" tab, click "Options," and then select "Advanced." Scroll down to the "General" section and click "Web Options." In the "Browsing history" section, click "Delete" and then select "Temporary Internet files and website files." Click "Delete" again to clear the cache.
   
3. Repair Office: You mentioned that you've already tried a repair, but it's worth trying again. To repair Office, go to the "Control Panel" and select "Programs and Features." Find Microsoft Office in the list of installed programs, right-click it, and select "Change." From there, you can choose to repair Office.
   
4. Uninstall and reinstall Office: If none of the above solutions work, you may need to uninstall and reinstall Office. Before doing so, make sure you have your product key and any installation media you may need. To uninstall Office, go to the "Control Panel" and select "Programs and Features." Find Microsoft Office in the list of installed programs, right-click it, and select "Uninstall." Once Office is uninstalled, you can reinstall it using your product key and installation media.

I hope one of these solutions works for you!