
	Home > SAP Tips > Basis administration > Eliminating blank Excel views in list edits

SAP Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

BASIS ADMINISTRATION

Eliminating blank Excel views in list edits

Haitham Gharandoq
08.08.2003
Rating: -4.32- (out of 5) Hall of fame tip of the month winner

Digg This!

StumbleUpon

Del.icio.us

When you're viewing the list edit results you may want to switch from SAP grid view to Excel view. But instead, you get a blank list! This is annoying, but you can solve this issue by following the following simple steps:
1. Open an empty Excel spreadsheet.
2. On the Tools menu, click Options.
3. Click the Security tab.
4. Under Macro Security, click Macro Security.
5. Click the Security Level tab, and then select the security level you want to use: Medium
6. Click the Trusted Sources tab.
7. Click the Trust all installed add-ins and templates and Trust access to Visual Basic Project.

Rate this Tip
To rate tips, you must be a member of SearchSAP.com. Register now to start rating these tips. Log in if you are already a member.
Submit a Tip

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Basis administration
	Select Text fields: Case-insensitive
	Finding BADIs you can use
	Easier maintenance of output types, procedures, conditions, etc.
	Is this the quickest way to find a BADI?
	Top 10 SAP tips of 2007
	Dealing with backup server instability
	SAP security audit log setup
	Do not use SAP GUI with Internet Explorer 7 Beta
	How to reinstall the Support Package Manager from the command line in SAP Basis
	Display locked and unlocked SAP transactions

SAP Basis

Basis consultant wants to learn NetWeaver Portal

SAP administration information for a Basis interview

Quiz: SAP ABAP development

What does the Parameter tab mean in SU01

Changing a customer message priority level after it's sent

Basis administration info in preparation for an interview

Easier maintenance of output types, procedures, conditions, etc.

Fixing inconsistencies in TemSe and Spool systems

Is this the quickest way to find a BADI?

RFC timeout problems

SAP Basis Research

SAP security

SAP administration information for a Basis interview

Quiz: SAP ABAP development

Restricting sales document assignments by sales area

Authorization objects with a value of single/double quote marks

Error logging in using a reference ID

Easier maintenance of output types, procedures, conditions, etc.

Security risk: Users able to see data from other companies

Assigning roles to all users in a group

On The Spot: Mario Linkies on SAP security

SAP delivers Web services for GRC integration

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

Basis (SearchSAP.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2000 - 2008, TechTarget \| Read our Privacy Policy SearchSAP.com is a search service provided by TechTarget and is completely independent of and not affiliated with SAP AG.