Sudden Issue Exporting Reports to Excel

Yes, my thoughts exactly. Thanks for all your help :)
 
I just checked my Windows update history and there were dozens of updates that were installed on 7/11/2014 both for Access 2007 and for Office 2010. I am thinking one of these--or some combination of several updates--may be causing this sudden issue.
 
I uninstalled most of the updates and it is now working. So I am getting closer....
 
Nope I was mistaken. I am going to give up now. It's not worth it...
 
Rather than uninstalling updates that you actually need, best you re-install Access alone.
 
Point taken but Windows is just going to reinstall them when I reboot anyway so it is not a huge deal.

I wanted to see if it would make a difference since the timing of the updates coincides with the report to Excel function not working but it didn't.

I don't want to reinstall Access for this (I am using a standalone copy and only get so many installs). Just going to live with the loss of functionality.
 
I see!

I would imagine the standalone copy can be reinstalled as many times as you wish because the verification is done online. As long as it's the same machine.

By the way, you don't have two different versions of Access running on your machine do you?
 
I finally fixed this.

I had a sneaking suspicion that something with Office 2010 was conflicting with Access 2007 since I checked my coworker's computer (Office 2013) and the export to Excel was functioning properly. Besides the export to Excel issue, I also started getting other weird errors that seemed related to Office 2010 (long story short: office was trying to "install" Access every time I opened a .accdb file from explorer but it wasn't working because we don't have Access included in our Office Suite).

In any case, to solve this I uninstalled Office 2010 and installed 2013. Now everything is working properly.

Thank you again for all your help!
 
Yes that comes up when there's a conflict. Now I think there's a workaround for this but I don't really bother. You could install one version on a Virtual Machine on your PC and I think that should work nicely.

Good to hear you got to the bottom of this.
 

Users who are viewing this thread

Back
Top Bottom