Problem send to excel in NAV 5.0

GetSmart

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!

ara3n

open the log file. What does it say?

GetSmart

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

Administrator

[Topic moved from Dynamics Mobile to NAV/Navision forum]

MBerger

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 : \ / ? * [ ]

ara3n

yep I agree with MBerger

canadian_bacon

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_dm

Hello how this problem can be solve sending to excel please advise.

thanks you,
jonjon

vasvovec

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.