Copy to Excel 2007 bug?

mgmmgm Member Posts: 126
I am using the old fashioned copy to Excel functionality, ie. select records in a table, Ctrl+C, goto Excel and press Ctrl+V/
Somehow Excel 2007 can not handle this, it doesn't split the records correctly; I get lesser rows in Excel than records I have selected in NAV.
In one Excel cell it posts a full record.

Does anyone know if this is a known bug and if there is a fix for this?

Maarten

Comments

  • SavatageSavatage Member Posts: 7,142
    Do you get different results if use the Excel "Paste Special" option instead of CTRL-V?
  • idiotidiot Member Posts: 651
    Look for special (eg white space) or "tab" characters stored in the fields.
    Deleting those should work.
    The last record copied should give you an idea of where to look.
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
Sign In or Register to comment.