Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Excel/OpenXML Setup
jimbates
Member Posts: 3
We are in the middle of redeploying NAV 2013 for many of our users. We had been using one click deployment for everyone, but are needing to use a standard install for many users. We are running into to two issues.
First, NAV is looking for OpenXMLSDKv2 instead of OpenXLMSKDv25 when doing an Excel export from NAV. Our updated OneClick client install still seems to use the 2.5 version rather than 2.0 version. I think we are using the same build (NAV 7.0.35345.0 for both our new deployment and our existing standard deployment). The output is different between our new standard deployed clients and our existing standard deployed clients. What do I need to do to get us on the 2.5 version for everyone?
Second, NAV can only have one xml/xls file open that was exported from NAV at a time. The second file shows an empty spreadsheet, but, if you save it and reopen it, the data is there. What do we need to do be able to see the data in multiple excel exports? This may resolve if I can fix the first issue.
Thanks
Jim
First, NAV is looking for OpenXMLSDKv2 instead of OpenXLMSKDv25 when doing an Excel export from NAV. Our updated OneClick client install still seems to use the 2.5 version rather than 2.0 version. I think we are using the same build (NAV 7.0.35345.0 for both our new deployment and our existing standard deployment). The output is different between our new standard deployed clients and our existing standard deployed clients. What do I need to do to get us on the 2.5 version for everyone?
Second, NAV can only have one xml/xls file open that was exported from NAV at a time. The second file shows an empty spreadsheet, but, if you save it and reopen it, the data is there. What do we need to do be able to see the data in multiple excel exports? This may resolve if I can fix the first issue.
Thanks
Jim
0