Nav 4.3 cut and paste to Excel problem

twdavis
twdavis Member Posts: 79
edited 2009-01-08 in NAV/Navision Classic Client
Has anyone had a problem with cut and pasting data from Navision 4.3 data lists to Excel?
Workstation OS is XP Pro, Excel is Win 2003 current with latest updates.
Problem is that the data is pasting into Excel as one long string of data with cariage return symbols between each field value. Problem only recently started occuring.
Is there a setting somewhere in Excel that controls this feature?

Thanks

Comments

  • Savatage
    Savatage Member Posts: 7,142
    are you getting the data from a table or table type form?

    Have you tried Paste Special - and try those options?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • twdavis
    twdavis Member Posts: 79
    Paste Special did not work either.
    Per Microsoft, this problem occurs with several other software applications and they have a hotfix. But the is no mention of Navision.

    Any other ideas?
  • Savatage
    Savatage Member Posts: 7,142
    Problem only recently started occuring.

    Can you trace back to see if anything was changed?

    is it all tables or just one?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • garak
    garak Member Posts: 3,263
    is this also if you mark only the first cell in excel or also if you mark the worksheet ?
    Do you make it right, it works too!
  • jversusj
    jversusj Member Posts: 489
    to answer your question, i did not have this problem when i worked in 4.0 sp3. we had the native DB, not SQL, if that makes a difference. good luck!
    kind of fell into this...
  • twdavis
    twdavis Member Posts: 79
    It has to be a problem with the workstation Excel recent Microsoft updates. We CAN copy and paste the same data source from another workstation that does not have the most recent updates from Microsoft.

Categories