Problem send to excel in NAV 5.0

GetSmartGetSmart Member Posts: 17
I'm having problems in exporting to Excel for the Nav 5.0 .For instance I use the "Send to Microsoft Office Excel" button to export the data in the Payment Journals data to Excel, but when i doing this then the following message:

Problems came up in the following areas during load:
Workbook Setting

This file cannot be opened because of errors. Errors are listed in C:\Documents and Settings\<user name>\Local Settings\Temporary Internet Files\Content.MSO\2B35508E.log

Any assistance would be appreciated!
GetSmart

Comments

  • ara3nara3n Member Posts: 9,255
    open the log file. What does it say?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • GetSmartGetSmart Member Posts: 17
    Log files message as below:

    XML ERROR in Workbook Setting
    REASON: Bad Value
    FILE: C:\Documents and Settings\<username>\Local Settings\Temp\AMB-FEB09 PV 01~172 02 - Payment Journal.xml
    GROUP: Workbook
    TAG: Worksheet
    ATTRIB: Name
    VALUE: AMB-FEB09 PV 01~172/02 - Pa1

    XML ERROR in Workbook Setting
    REASON: Bad Value
    FILE: C:\Documents and Settings\<username>\Local Settings\Temp\AMB-FEB09 PV 01~172 02 - Payment Journal.xml
    GROUP: Workbook
    TAG: Worksheet
    ATTRIB: Name
    VALUE: AMB-FEB09 PV 01~172/02 - Pa2
    GetSmart
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,495
    [Topic moved from Dynamics Mobile to NAV/Navision forum]
  • MBergerMBerger Member Posts: 413
    I got this once too : there are restrictions to the names of worksheets in Excel.
    -Maximum of 31 characters
    -May not be empty
    -May not contain any of the following characters : \ / ? * [ ]
  • ara3nara3n Member Posts: 9,255
    yep I agree with MBerger
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • canadian_baconcanadian_bacon Member Posts: 91
    xml tag names cannot begin with a number. So, the fields "1099 Code" and "1099 Amount" will cause errors. One simple way to get around this is to just rename the fields to "X1099 Code" and "X1099 Amount".
  • jonjon_dmjonjon_dm Member Posts: 3
    Hello how this problem can be solve sending to excel please advise.

    thanks you,
    jonjon
  • vasvovecvasvovec Member Posts: 8
    GetSmart wrote:
    Log files message as below:

    XML ERROR in Workbook Setting
    REASON: Bad Value
    FILE: C:\Documents and Settings\<username>\Local Settings\Temp\AMB-FEB09 PV 01~172 02 - Payment Journal.xml
    GROUP: Workbook
    TAG: Worksheet
    ATTRIB: Name
    VALUE: AMB-FEB09 PV 01~172/02 - Pa1

    I got such error today and solve it.
    You need to export common Style sheet for Excel "NavisionFormToExcel" from Nav. Then you need to find this string in it:
    <xsl:value-of select="concat(substring($TableBoxCaption,1,27),string(position()))"/>
    and then you need change it like:
    <xsl:value-of select="concat(substring(translate($TableBoxCaption,'/',''),1,27),string(position()))"/>

    Added function translate() to remove '/' chars.

    Then you should save style sheet and import it back to Nav.
Sign In or Register to comment.