We help IT Professionals succeed at work.

Office 2013 upgrade

what is the impact of 2013 upgrade in an organisation?

What are things to look at?

For example I discovered that upgrading to access  2013 will not open office 2003 database

What are others things to pay attention to ? Is there a list of known issues after upgrading?
Comment
Watch Question

Phillip BurtonDirector, Practice Manager and Computing Consultant
Awarded 2014
Top Expert 2014

Commented:
If you are upgrading from 2003 or earlier, the toolbar system is completely different, and there would be some retraining.
Outlook 2013 will not connect to an Exchange 2003 server unless you use POP or IMAP.

New versions of Access have lost some of the earlier controls, and things like DatePickers may need to be replaced for example.

Then there's the standard document format which isn't necessarily backwards compatible without installation of file viewers / converters (i.e. new versions can open older document formats, but not vice versa)
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
New versions of Access have lost some of the earlier controls, and things like DatePickers may need to be replaced for example.
To be clear: Access never had a Date picker. Many people used ActiveX controls, and now find that ActiveX controls are becoming less supported in newer versions. To be fair, MSFT has long advised that you NOT use non-compliant ActiveX controls in the Access environment, but quite a few people didn't listen to that advice and now are paying the cost for it.

I can open several Access 2003 databases with Access 2013, so it can be done. However, in many cases an Access database was improperly developed, and uses items that are not compliant with 2013 (re: the ActiveX controls mentioned earlier). If that's the case, then your 2003 database would not be compliant.

That said - generally it's a good idea to convert your databases to the new format. Doing so makes life easier, since you'll be working in 2013 anyway.

It's a big jump from 2003 to 2013, and quite a lot has changed. There is no more database window, for example. You now have the Navigation Pane. As Philip mentioned, the Ribbon has taken over, and many have troubles with it (especially if you have custom menus and toolbars).

We saw a fair amount of code fixes that had to be done, but almost all of that was the result of poor/lazy coding methods, and as Access matured, it became less tolerant of those practices. For example, often we would see the Filter argument of the OpenReport method used, when the Where argument should have been. Earlier versions of Access handled that correctly, but starting in 2007 Access would complain if you had not properly formed that method. There were others as well - I no longer have the list, but I'm sure it's out there somewhere.

Author

Commented:
Thank you so much they are a few users on 2003 , the majority of users use Office 2010,

I have been tasked to come up with list of issues that might be affected, thank you for mention access and activex controls,

Is there any issue in Excel or Word ?

are they any other tools to run from the server to get an idea of what users do like Office Telemetry
https://technet.microsoft.com/en-us/library/jj863580.aspx
Phillip BurtonDirector, Practice Manager and Computing Consultant
Awarded 2014
Top Expert 2014
Commented:
I've not run across any problems in Excel or Word - apart from the fact that all of the menus ARE IN CAPS.
 
There are various variants of Excel - see the article PowerMap in Excel for the variants which are needed for something like PowerMap, so you might want to be careful as to what you get.

I would suggest updating one or two computers and seeing If there is a problem.
Commented:
thanks once again i think i have an idea of the impact of Office 2013 rollout and what to expect

I got this link as well about known issues for office 2013

https://support.office.com/en-ie/article/Office-2013-known-issues-e9fe113d-fe57-42d9-aaf3-0e112ea4655a?ui=en-US&rs=en-IE&ad=IE
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
"If you are upgrading from 2003 or earlier, the toolbar system is completely different, and there would be some retraining."

Specifically, starting in Office 2007, the Ribbon menu system was introduced and remains today.
Up to and including A2010, your legacy custom menus (if any) can still be used without the Ribbon being show. However, in A2013 ... wherein legacy menus are still (barely) supported, they will show up on the 'Add-In's Ribbon ... and cannot replace the Ribbon.

So ... bottom line is you might as well get used to the Ribbon.  And FORTUNATELY, there is an outstanding de-facto standard tool available (nothing is supplied by Microsoft) for creating custom Ribbons:

http://www.ribboncreator2013.de

I use this tool frequently.

Author

Commented:
thank you all