Great Plains smartlist export to Excel or Word error

I get the "unexpected error, quitting" message when trying to export from Microsoft Business Solutions Great Plains to Excel or Word.  If added to the Power Users or Administrators group, it exports properly.  However this is an unacceptable solution due to security risks.  We have granted the users full NTFS file rights within the MS Office and Great Plains folders.  We set the Macro security to low on both Word and Excel.
costcotravelAsked:
Who is Participating?
 
costcotravelAuthor Commented:
Thank you Rich, one of the google groups links gave me the clue we needed.  We logged on locally, opened up Excel and Word and then logged into Great Plains with the sa account and did an export (successfully) and then logged out and had the user try again.  No need for Power User rights, phew!
Thanks
-©hris
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.