Error during Send to Microsoft Office Excel.

mart1n0
mart1n0 Member Posts: 123
edited 2009-06-16 in NAV/Navision Classic Client
When trying to Send to Microsoft Office Excel I always get the following error:
The file cannot be opened because of errors. Errors are listed in: C:\Documents and Settings\<username>\Local Settings\Temporary Internet Files\Content.MSO\42B979A8.log
The errors in the log file are all the same type:
XML ERROR in Table
REASON: Bad Value
FILE: C:\Documents and Settings\<username>\Local Settings\Temp\2\<vendor name> - Purchase Order.xml
GROUP: Cell
TAG: Data
VALUE: 08.06.09
It seems like it the date is not accepted with point but that is the way the customer wants to show the dates. Why can't the date be used with dots?

If anyone has a solution for this that would be very much appreciated!

Answers

  • jannestig
    jannestig Member Posts: 1,000
    Isn't this because your local settings for Date seperation characters are cauing this value to recognized as an error.

    Have you tried to set a machine with the date format you are using and then tried to export ?
  • mart1n0
    mart1n0 Member Posts: 123
    Problem solved.

    Dynamics NAV 5.0 has some problems when exporting forms with the default stylesheet for Excel. Importing the default stylesheet for Excel from NAV 5.0 SP1 solved the problem.

Categories