topic Re: Blank Excel Spreadsheet in Application Development and Automation Discussions

Blank Excel Spreadsheet

Former Member — Mon, 11 Dec 2006 08:38:59 GMT

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

Former Member — Mon, 11 Dec 2006 08:46:39 GMT

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

Former Member — Mon, 11 Dec 2006 09:44:53 GMT

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

Former Member — Mon, 11 Dec 2006 10:01:55 GMT

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.

Former Member — Mon, 11 Dec 2006 10:22:32 GMT

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