Background spool report rows goes missing when export to excel file

[Former Member]

Hi experts,

When we have executed job in the background (1174 Rows), and there is a spool created for this. Then, we choose file save as from the spool to excel file, and here we find that there is only (755 Rows) that has been transfered. We have approx (420 Rows) which is not being transfered from the spool to excel. When we view in the spool all 1174 Rows are there but exporting to excel the rows go missing.

Please help.

Thanks.

Regards,

Thava

[Former Member]

Hi experts,

When we have executed job in the background (1174 Rows), and there is a spool created for this. Then, we choose file save as from the spool to excel file, and here we find that there is only (755 Rows) that has been transfered. We have approx (420 Rows) which is not being transfered from the spool to excel. When we view in the spool all 1174 Rows are there but exporting to excel the rows go missing.

Please help.

Thanks.

Regards,

Thava

[Former Member]

Hi,

Please check your spool settings.

I guess the display pages are less than the number of pages of the list

Please check at SP01->goto the spool outpur -> GOTO-> Display Requests->>Setting and check the number of pages defined there.

hope this soles your problem,

Thanks,

Raj

[Former Member]

Hi,

I have increased the number of pages from 10 to 100. Yet the number of records are less than 1174 which is 755 rows. Please be informedthat, if I execute the progrma to run in foreground and then export to excel then i get all the records 1174 rows. The problem only happens in background.

Thanks.

Regards,

Thava

[Former Member]

Reply from OSS:

The missing rows will be seen if you start Excel and then use

File ->Open to open the downloaded file.

For deatil information please refer to the attached note:

569537 Incorrect data during import into Excel

Hope above information will help.