Export to Excel no data to certain users

When I export any adv find results to a dynamic worksheet a particular user
cannot get refreshed data when accessing the Excel file. This is not machine
dependent. It also appears to be independent from his access to the recors
since he can access the records in the queries. In fact, he owns all the
records in one particular query.

He is a member of the same teams & roles as others who can access the same
data.

I'm thinking its a SQL access issue.

Are there special security settings associated with dyanmically linked
worksheets?

SarahMontgomery
Tue Apr 04 13:42:04 CDT 2006

I figured this out. The affected users' logins had been changed by the
network admin since the creation of their CRM accounts. I had to update the
domain logon name in SQL. They can now access the data.

"Sarah Montgomery" wrote:

> When I export any adv find results to a dynamic worksheet a particular user
> cannot get refreshed data when accessing the Excel file. This is not machine
> dependent. It also appears to be independent from his access to the recors
> since he can access the records in the queries. In fact, he owns all the
> records in one particular query.
>
> He is a member of the same teams & roles as others who can access the same
> data.
>
> I'm thinking its a SQL access issue.
>
> Are there special security settings associated with dyanmically linked
> worksheets?
>