Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Blank Excel Spreadsheet

Former Member
0 Likes
615

How Do Everyone!

When I run my transaction to produce an excel spreadsheet in production,

a blank spreadsheet is created. I am logged in at my PC under my userid.

If someone else logs in my PC under a different userid they also get a

blank spreadsheet. However, if the same user logs in at their own PC

they can produce the spreahseet. I originally thought it was an ABAP issue

but I think it must be something else.

Any ideas anybody.

Andy

4 REPLIES 4
Read only

Former Member
0 Likes
528

Hi Andy,

Try this :

Under excel :

You must select the 'Access Visual Basic Project' option under Tools -> Macros -> Security.

And level security at low or averagely low.

Ref to oss : 552915

Erwan

Read only

0 Likes
528

Erwan,

Many thanks for your reply.

I have changed my settings to what you suggested but I am still

getting a blank sheet. The other user I mentioned has also the

same settings.

Andy

Read only

0 Likes
528

Andy,

What you have to do is opening excel, do the modification provided, then close excel.

Normally, the next download from SAP should work.

Erwan.

Read only

0 Likes
528

Erwan,

I have tried this quite a few times without any success.

I have also tried it on other PC's with my userid and the excel works ok.

I just can't see what the problem is.

Any other suggestions

Andy