EternalMyrtle
I'm still alive
- Local time
- Today, 04:17
- Joined
- May 10, 2013
- Messages
- 533
Yes, my thoughts exactly. Thanks for all your help 
Sudden Issue Exporting Reports to Excel
- Thread starter EternalMyrtle
- Start date
EternalMyrtle
I'm still alive
- Local time
- Today, 04:17
- Joined
- May 10, 2013
- Messages
- 533
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.
EternalMyrtle
I'm still alive
- Local time
- Today, 04:17
- Joined
- May 10, 2013
- Messages
- 533
I uninstalled most of the updates and it is now working. So I am getting closer....
EternalMyrtle
I'm still alive
- Local time
- Today, 04:17
- Joined
- May 10, 2013
- Messages
- 533
Nope I was mistaken. I am going to give up now. It's not worth it...
EternalMyrtle
I'm still alive
- Local time
- Today, 04:17
- Joined
- May 10, 2013
- Messages
- 533
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 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 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?
EternalMyrtle
I'm still alive
- Local time
- Today, 04:17
- Joined
- May 10, 2013
- Messages
- 533
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!
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.
Good to hear you got to the bottom of this.
Similar threads
