smartlist & excel

Brian

unread,

Sep 13, 2005, 1:23:03 PM9/13/05

to

I am running version GP version 8.0 and MS Office for XP. I have the same
configuration on 3 other machines, those 3 are able to export smartlist
results into excel and word. One workstation gets an error when I click on
either the excel or word button on the smartlist.
the error reads "Unexpected Error;quitting"
any ideas?

Polino@discussions.microsoft.com Mark Polino

unread,

Sep 13, 2005, 1:30:03 PM9/13/05

to

I've seen this happen with permissions on the box. The user has to have a
certain level of permission to the local machine. Try looking at the local
machine permissions for the machines that work oK.

Mark

Dean Anderson

unread,

Oct 6, 2005, 2:06:03 PM10/6/05

to

I've just started receiving this error on two of 20 machines. Did the TK
help resolve the issue. I know it's permissions related, but no one can seem
to explain which registry I need to make the change in. Or does Great Plains
require users to be Administrator. I'm running 7.5 and never had this
problem before. If you have details on the solution I would appreciate some
help. GP support & my VAR haven't found the solution.
--
Thanks,
Dean Anderson

"Marisol" wrote:

> Yup.. I've seen it too. There's a TK too. KB851235.
> --
> Marisol Mortera

Microsoft Dynamics GP

unread,

Oct 6, 2005, 4:26:46 PM10/6/05

to

Try this.

Logon as a user with Admin rights to the LOCAL machine. See if solves
the problem. If so, logon as a user with POWER USER rights to the
machine and see if that works. I believe, power user will work and that
has been a reasonable compromise in companies where I've seen the
problem so I haven't chased it farther.

Mark Polino

Victoria [MVP]

unread,

Oct 6, 2005, 5:06:39 PM10/6/05

to

Just out of curiosity - do you find that the computers that are having the
issues are ones where the user has changed? In other words, person who was
using GP left company and another user now has their computer?

--
Victoria Yudin
Microsoft MVP - Great Plains

"Dean Anderson" <DeanAn...@discussions.microsoft.com> wrote in message
news:0D49048F-3ABE-48FA...@microsoft.com...

Dean Anderson

unread,

Oct 6, 2005, 5:34:04 PM10/6/05

to

We have tried this, it was one of the first suggestions. No effect.
Changing the user to an Administrator also did not work.
We are moving on to TK851235 resolution 2 - HKCR\TypeLib\ validation of the
keys user access.
I was under the impression if I installed the product as administrator that
these keys automaticly registered. This particular user was part of the
Debugger group previously.
--
Thanks,
Dean Anderson

Dean Anderson

unread,

Oct 6, 2005, 5:37:02 PM10/6/05

to

No. Actually this machine has been working fine for the last 4 months. Then
about three weeks ago she started getting the "unexpected error" message. We
have already tried uninstall of GP and Office and re-installed with no
success.
--
Thanks,
Dean Anderson

Victoria [MVP]

unread,

Oct 6, 2005, 6:03:40 PM10/6/05

to

Dean,

I don't know 100% if this is accurate, but I have been told that not only do
you need to install both Office and GP as the local administrator on a
machine, but you also need to go into Excel and Word to initialize them AND
go into GP as 'sa' to initialize SmartList and the Excel Budgeting Wizard,
all as the local admin. Apparently installing and 'initializing' this way
allows for everything to happily coexist and work for any subsequent Windows
user on the machine without those users needing to be local admins. Again,
don't know if this is indeed the case, but may be worth a try if this
problem seems to be escalating.

--
Victoria Yudin
Microsoft MVP - Great Plains

"Dean Anderson" <DeanAn...@discussions.microsoft.com> wrote in message

news:3F0E000F-12E4-4BE8...@microsoft.com...

Khalid Dhariwal

unread,

Oct 7, 2005, 4:43:25 AM10/7/05

to

Hi,
Please give permission to following three registry entries:
Typelib
Interface
CLSID

Good way is to create GreatPlains group and give that group full
permissions.
Regards,
Dhariwal

"Dean Anderson" <DeanAn...@discussions.microsoft.com> wrote in message

news:0D49048F-3ABE-48FA...@microsoft.com...

Dean Anderson

unread,

Oct 14, 2005, 12:17:05 AM10/14/05

to

Actually we seem to have stumbled on another way to cure the problem. My IT
person had been loading the operating system, then Microsoft Office, but
neglected to launch Excel, Word, Access, Outlook as system admin. He would
leave this up to the individual users.
In our test process we changed and loaded MS Office, the opened each program
as admin. Then we progressed to installing GP and the service pack (6).
When the use id was used smart list worked perfectly. We tried 5 different
user ID. All acted as expected.
Our problem now has switched over to Adobe. Not all user id's allowed PO/SO
to generate documents to email to Vendor's/Customer's. We just downloaded
REGMON from sysinternal to see if we can isolate the registery impacted.
--
Thanks,
Dean Anderson

Victoria [MVP]

unread,

Oct 14, 2005, 3:28:36 AM10/14/05

to

Dean,

Thanks for the update, glad to hear that you found a solution to the
SmartList problem.

Can you give some more details on the Adobe issue? I am guessing you're
trying to use the 'Send to PDF' functionality? Are you getting an error?

--
Victoria Yudin
Microsoft MVP - Great Plains

"Dean Anderson" <DeanAn...@discussions.microsoft.com> wrote in message

news:540F98DB-632A-4102...@microsoft.com...