Hi All,
I find it very useful to copy data from tables out of Navision and paste the data into excel, however on occasions the data will paste into the fist cell in each row of excel, instead of a new cell for each field.
Generally after a few hours the problem resolves itself but seems to reoccur on occasion.
I’m using Navision 4.0 SP3 & MS Excel 2007
Anyone have any ideas ?
Matt
I had something very similar to this when I had a double quote in a text field. I blogged about it here and someone left a comment saying:
This is because excel use function “Text to Columns” to separate pasted text. And by default this function use Quota as “Text qualifier”.
To workaround this problem, before pasting you should run this excel function (Data->Text to Columns)and set “Text Qualifier” to “None”. Now excel will normally paste texts with quotas until you restart excel.
I’m wondering whether this Text Qualifer is what is messing things up for you? Maybe you are not using the Tab character as the column seperator when it does not work?
Sweet, that makes sense. Will give it a go next time it plays up.
Thanks heaps ! [:)]
Hi Matt,
Can you please click on “Verify Solution” on Gaspode’s post if you feel it solves your problem - it will help other seaching for a solution