Great Plains - Smart List Erroring on Export to Excel 2010

I have recently installed Great Plains version 8 on a Windows 7 Professional (32 bit) OS with Office 2010. The smart list will run fine until you try an export it to Excel or Word and then you get an error message saying "Unexpected Error; Quiting". I've set the users permissions on the local machine to administrator and logged into GP as Sa and still get the error. Has anyone ran across this before and found a solution? Thanks.

I know this configuration works with GP 8, XP Pro, and Office 2003 - but I can't get it to work with GP 8, Windows 7, and Office 2010.
LVL 1
HLF_DavidAsked:
Who is Participating?
 
Victoria YudinConnect With a Mentor Owner / Dynamics GP ConsultantCommented:
Unfortunately, GP 8.0 is not supported on Windows 7, nor with Office 2010...so....you may be out of luck here.  However, here is what I would try: log into Windows as the local built-in administrator (note that this is not the same as a user in the administrators group) and first launch Excel, then go into GP and try the export again.  It may just work.  If so, this will most likely now work for other Windows users.  
0
 
HLF_DavidAuthor Commented:
Victoria,

I took your advice and it worked great. Thanks for the help!

This is what I did.
1. Logged into the computer as the local admin.
2. Lanched GP as SA
3. Ran Smart List - Export to Excel (it worked)
4. Logged off as local admin
5. Logged in as the domain user
6. Lanched GP as the domain user
7. Ran Smart List - Export to Excel (it worked)


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.