Skip to Content

sap bo 4.1 . When i schedule report it saves in (.xlsx) but i need in (.xls)

sap bo 4.1 . When i schedule report , it saves in Microsoft Excel Worksheet (.xlsx) but i need in Microsoft Excel 97-2003 Worksheet (.xls))

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 09, 2016 at 04:25 PM

    In the destination when you mention the name of the report, just mention %SI_NAME%.xls. See if that works

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2016 at 12:30 PM

    Thanks for quick response

    File shows as xls and file type in xlsx

    Thanks,

    Raghunath

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 11, 2016 at 06:33 AM

    we are using macros , macros accepts only xls file

    Add comment
    10|10000 characters needed characters exceeded

    • What does your macro look for .xls extension or Type of file? I dont know much about Macros, but I think they only look for file name and extension. Another suggestion would be to find a macro or script that can convert .xlsx format to .xls in excel.