mibuso.com

Microsoft Business Solutions online community
It is currently Thu Nov 27, 2014 4:55 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Export from NAV 2009 R2 to Excel 2000
PostPosted: Mon Apr 02, 2012 9:37 am 
Offline

Joined: Mon Apr 02, 2012 9:29 am
Posts: 3
Country: Italy (it)
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


Top
 Profile E-mail  
 
 Post subject: Re: Export from NAV 2009 R2 to Excel 2000
PostPosted: Mon Apr 02, 2012 2:01 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 8:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
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?

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Export from NAV 2009 R2 to Excel 2000
PostPosted: Mon Apr 02, 2012 4:49 pm 
Offline

Joined: Mon Apr 02, 2012 9:29 am
Posts: 3
Country: Italy (it)
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...


Top
 Profile E-mail  
 
 Post subject: Re: Export from NAV 2009 R2 to Excel 2000
PostPosted: Mon Apr 02, 2012 5:03 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 8:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
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?

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: Export from NAV 2009 R2 to Excel 2000
PostPosted: Tue Apr 03, 2012 2:19 pm 
Offline

Joined: Mon Apr 02, 2012 9:29 am
Posts: 3
Country: Italy (it)
Yes, with Ctrl-C and Ctrl-V it works fine.

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


Top
 Profile E-mail  
 
 Post subject: Re: Export from NAV 2009 R2 to Excel 2000
PostPosted: Tue Apr 03, 2012 4:06 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 8:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
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.

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: slmaluwa and 18 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: