Excel export not showing data

(0) Share

Report

Posted on by Community Member

In a CRM online environment (7.1.2.1039) a user export the members of a marketing list to excel.

Depending on the user the excel shows data or not. If I open the excel in Notapad I can see data in both excel files.
The excel created by a user with problems can be opened but shows no data (worksheet) not on her/his system and not
on someone elses.

What can cause this problem? Is this caused by the office installation? Or what else?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

TheMarkChristie 10,328 Moderator on at

Like (0)

Report

I think you may need to clarify a few things first,

Person A Can download the file and open it with no problem

Person B Can download the file and not see anything

Can Person B open Person A's File and see anything?

Can Person A Open Person B's File and see anything?

What can Person C see on both of the files?

For me it sounds like either an excel installation isuue or permissions

Was this reply helpful? Yes No
Suggested answer

JayeshAC 1,157 on at

Like (0)

Report

Hi Robin,

can you do the following activity in your Excel.

1. Open Excel

2. Go to File > Options.

3. Go to Trust Center > Trust center settings.

4. Click Protected view. Then clear the check boxes for the first two options.

5. Click OK and then close the Options dialog box.

check whether it resolves your issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mark,

Can Person B open Person A's File and see anything? Yes

Can Person A Open Person B's File and see anything? No (have tested this)

Person C can open file from person A and see the data, opening file from person B looks empty.

I agree with you that it looks like an office issue, but can't stand it that I don't know how or what to solve :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi Jayesh,

This did solve the problem, but doesn't explaim what happens. Why can I do the export and open it from my system and can't open the file from someone else?

On my system the both checkboxes where checked and I could still open my exported files. ....????.....

Was this reply helpful? Yes No
Suggested answer

JayeshAC 1,157 on at

Like (0)

Report

Hi Robin,

When you open excel for the first time, it asks you to enter your name and initials. It usually picks up your name from your login ID and save it.

So whenever you opens an excel it will take bydefault these credentials.

Was this reply helpful? Yes No