Export from NAV 2009 R2 to Excel 2000

ElenaPanzeri · **Posted:** Mon Apr 02, 2012 10:37 am

I tried to export NAV forms to Excel but all the information is insert in only one box.

Version NAV: 2009 R2
Version Excel: 2000

Is there a sort of incompatibility between the two versions?

Thank you,
Elena

Savatage · **Posted:** Mon Apr 02, 2012 3:01 pm

Excel 2000?
Why are you on such an old version?
When you paste are you just pasting or " pasting special"
It's going to hard to answer about its comparability because I doubt their are Alot of users who have purchased nav2009 and still use excel2000.

Can we assume this is some kind of table form like the item list?

ElenaPanzeri · **Posted:** Mon Apr 02, 2012 5:49 pm

I'm using the NAV standard functions to export to Excel (style sheet).
We have tried to export table form, for example vendor list or customer list.
But all the information is insert in only one box...

Savatage · **Posted:** Mon Apr 02, 2012 6:03 pm

when you select the table & Ctrl-C & then go to excel & Ctrl-V - does it paste correctly?

if it does then it sounds like the Send to Excel in Nav2009 isn't compatable with excel 2000.

Are you not enjoying the benefits of Outlook and syncing? Or are you using Outlook 2000 also?

ElenaPanzeri · **Posted:** Tue Apr 03, 2012 3:19 pm

Yes, with Ctrl-C and Ctrl-V it works fine.

Mmh, I think they are using also Outlook 2000 ...

Savatage · **Posted:** Tue Apr 03, 2012 5:06 pm

Well it doesn't make much sence being on the newest Version of Nav and an ancient version of office.
Explain to whomever that the company can't be as productive as it should on office 2000 an an upgrade would be well worth the cost.

You can always download a free trial version of excel and if it exports correctly then you are 100% sure of how to fix your problem.

mibuso.com

Export from NAV 2009 R2 to Excel 2000

Who is online