Change worksheet name in default Send to Excel stylesheet

chrisxx83

Hi,
is there any way to change names of worksheet in default Send to Excel stylesheet?
Many of forms has caption longer than 31 chars, so I get error when I try to send them do Excel...
Thanks in advance

Koshe

could you write what kind of message do you get? I just tried to export a form with caption length of 40 symbols and everything worked (nav 2009 R2 classic).

chrisxx83

XML ERROR in Workbook Setting
REASON: Wrong VALUE
FILE: C:\Users\Krzysiek\AppData\Local\Temp\ZZ 11-12 09 230 MOBI - Zamówienie zakupu.xml
GROUP: Workbook
TAG: Worksheet
ATTRIB: Name
VALUE: ZZ/11-12/09/230 MOBI - Zamó3

XML ERROR in Worksheet Setting
REASON: Wrong VALUE
FILE: C:\Users\Krzysiek\AppData\Local\Temp\ZZ 11-12 09 230 MOBI - Zamówienie zakupu.xml
GROUP: Worksheet
TAG: Table
ATTRIB: ExpandedColumnCount
VALUE: 0

I'm working with NAV 5.0 SP1

Koshe

sorry, but I can't regenarate same situation because if I try it, my Navision stops working. The only guess is the caption containing polish characters and the location on the mashine is set incorectly.