Link to home
Start Free TrialLog in
Avatar of costcotravel
costcotravel

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Rich Rumble
Rich Rumble
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of costcotravel
costcotravel

ASKER

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