cancel
Showing results for 
Search instead for 
Did you mean: 

Header repeats in the excel export of reports

Former Member
0 Kudos

Dear All,

I have a problem when exporting the data to the excel. Header is getting repeated after 60000 lines page breaks and header repeat should not occur as per the client requirement.

Hence please provide any suggestion to over come this issue.

Accepted Solutions (0)

Answers (1)

Answers (1)

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

go to SE80 and give programme as -salv_bs_admin_maintain and execute

select user specific settings

here you had to update the Export File for that particular User id

with this you can avoid inconsistency

Former Member
0 Kudos

Dear Siva Prasad,

Following your suggestion i have selected "Excel (in MHTML Format)" option among below mentioned.But still the result didn't change. Header column's are getting repeated after 60000 lines same as before.

Excel (in MHTML Format)

Excel (in MHTML Format for 2000/97)

Star Office 8 Calc / OpenOffice.org 2.0 Calc

Excel (in Office 2003 XML Format)

SAP-Internal XML Format

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

This is the Problem with the Excel Document which cannot accept more lines and the buffer system