BlueElephant
Topic Author
Posts: 1662
Joined: Fri Dec 29, 2006 7:16 am

Questions about upgrading to Office 2013

Thu Jan 31, 2013 1:44 am

I currently have Office 2010 which I got for free, and was thinking about upgrading to the new Office 2013. I know a decent amount about it, but wanted to see if there were any users who were testing the beta, or people who have updated already and had an opinion about it.

A bit about my usage. I am a heavy user of excel, powerpoint and word. My excel work requires huge data sets, lots of pivot tables, formatting etc. More than normal usage of power point, and normal usage of Word. Should I get an upgrade i'll be going for the Home/Student addition (just Excel/Powerpoint/Word)

I have a $15 upgrade for Windows 8 but do not plan to install it yet, not a fan at all.

Your thoughts are much appreciated.
 
vikkyvik
Posts: 11801
Joined: Thu Jul 31, 2003 1:58 pm

Questions about upgrading to Office 2013

Thu Jan 31, 2013 1:56 am

Office 2003, you say? I still have it and use it at home. Love it.

Oh wait....
I'm watching Jeopardy. The category is worst Madonna songs. "This one from 1987 is terrible".
 
BlueElephant
Topic Author
Posts: 1662
Joined: Fri Dec 29, 2006 7:16 am

Questions about upgrading to Office 2013

Thu Jan 31, 2013 2:15 am

Quoting vikkyvik (Reply 1):
Office 2003, you say? I still have it and use it at home. Love it.

I didn't mind Office 2003, and then I learned 2007 had extended excel to 1.4 million rows. (and I've actually had files that maxed that out as well...)
 
User avatar
Jetsgo
Posts: 2696
Joined: Thu Jul 17, 2003 6:31 am

Questions about upgrading to Office 2013

Thu Jan 31, 2013 2:27 am

Does Office 2013 require Windows 8? If so, I won't be getting it. I can't stand Windows 8, it's clearly designed for phones and tablets and in my opinion just doesn't work well on laptops and desktops. I'm also weary about their push for a subscription based service. I know they offer a traditional purchase, however they have openly admitted it will not receive regular updates.
Marine Corps Aviation, The Last To Let You Down!
 
User avatar
Dreadnought
Posts: 9832
Joined: Tue Feb 19, 2008 6:31 pm

Questions about upgrading to Office 2013

Thu Jan 31, 2013 2:37 am

Quoting BlueElephant (Reply 2):
excel to 1.4 million rows

You mean 1.04 million.

I am also a mega-user (being in telecom). The problem with Excel 2010 is that as you approach the limits of how much data it can handle, it gets more and more unstable. I have tables a 600K rows long, around 40 columns, a few of them calculated, where every step I take I have to save the file just in case I crash on the next step. Sometimes it makes it, sometimes not. Sometimes I try to recover from a saved point to discover the saved file is corrupted. Grrrrr!!!

My understanding is that 2013 lifts the memory limitations so that in principle you should be able to deal with more data (at least in 64-bit). So I'd probably jump on it - except for the fact that for the first time ever, I do not look forward to Windows 8 at all. I've been using Windows since Windows 2.11, late 80s, and have looked forward to each new version. But Windows 8 looks like an operating system for 3 year-olds. What's with these big blocky tiles??? If they try to push that new interface onto Office, I won't be using it for a long time yet.

BTW, the Office 2007 and 2010 GUI was a radical departure from the previous GUI, and it took me a while to get my bearings, but now I think it's brilliant. So maybe I am being unfair to Windows 8.
Forget dogs and cats - Spay and neuter your liberals.
 
rfields5421
Posts: 5563
Joined: Thu Jul 19, 2007 12:45 am

RE: Questions About Upgrading To Office 2013

Thu Jan 31, 2013 3:05 am

Quoting Jetsgo (Reply 3):
Does Office 2013 require Windows 8?

No - Windows 7 or Windows 8 - or Server 2008 R2 or Server 2012.

Quoting Jetsgo (Reply 3):
I'm also weary about their push for a subscription based service. I know they offer a traditional purchase, however they have openly admitted it will not receive regular updates.

The subscription based service is going to transition you from Office 2013 to Office 2015 to the next versions. The original Office 365 was Office 2010, and has now evolved to Office 2013.

A couple companies I know went to it back in the second half of 2011, and their transition from Office 2010 apps to Office 2013 was very smooth.

The stand alone verision will receive regular monthly security updates, and might receive a service pack at some point. Pretty much what you have currently with supported Office versions.
 
BlueElephant
Topic Author
Posts: 1662
Joined: Fri Dec 29, 2006 7:16 am

RE: Questions About Upgrading To Office 2013

Thu Jan 31, 2013 3:38 am

Quoting Dreadnought (Reply 4):
You mean 1.04 million.

Yeah I missed a decimal, good catch

I often work with data between 600 and 800k lines, and you're right about the stability.

I won't be switching over to Windows 8 for a while.... I know that Office 2013 works on 7 and was just seeking input from those that might have upgraded or tested it.

Quoting Dreadnought (Reply 4):
BTW, the Office 2007 and 2010 GUI was a radical departure from the previous GUI, and it took me a while to get my bearings, but now I think it's brilliant. So maybe I am being unfair to Windows 8.

From what i see, 2013 has nearly the same GUI as 2007/2010. And I hate the tiles too.
 
User avatar
nighthawk
Posts: 4781
Joined: Sun Sep 16, 2001 2:33 am

RE: Questions About Upgrading To Office 2013

Thu Jan 31, 2013 8:48 am

Quoting BlueElephant (Reply 6):
From what i see, 2013 has nearly the same GUI as 2007/2010. And I hate the tiles too.

From what I read it has a completely new interface, along the lines of Win8, and is now designed for use on tablets and touch screens. I also gather there are next to no new features in any of the applications, the only change is the interface.

Personally i dont see any point in upgrading, although i'm a very light user of them. Office 2007 lets me write a letter, that's all I need!
 
User avatar
kngkyle
Crew
Posts: 396
Joined: Wed Dec 27, 2006 3:33 am

RE: Questions About Upgrading To Office 2013

Thu Jan 31, 2013 8:58 am

Quoting Jetsgo (Reply 3):
Does Office 2013 require Windows 8? If so, I won't be getting it. I can't stand Windows 8, it's clearly designed for phones and tablets and in my opinion just doesn't work well on laptops and desktops. I'm also weary about their push for a subscription based service. I know they offer a traditional purchase, however they have openly admitted it will not receive regular updates.

There are a number of third party applications that essentially hide all of the Modern/Metro interface stuff and restore the the complete traditional desktop while keeping all of the performance enhancements that come with W8. Start8 is the best in my opinion, and only costs $5. (it does more than just add the start menu back)

http://www.stardock.com/products/start8/

I just got Windows 8 a few weeks ago, and prior to getting Start8 it was a little annoying to use on a desktop computer, but now it's great.
 
User avatar
Revelation
Posts: 13829
Joined: Wed Feb 09, 2005 9:37 pm

RE: Questions About Upgrading To Office 2013

Thu Jan 31, 2013 10:42 pm

Quoting Dreadnought (Reply 4):
I am also a mega-user (being in telecom). The problem with Excel 2010 is that as you approach the limits of how much data it can handle, it gets more and more unstable. I have tables a 600K rows long, around 40 columns, a few of them calculated, where every step I take I have to save the file just in case I crash on the next step. Sometimes it makes it, sometimes not. Sometimes I try to recover from a saved point to discover the saved file is corrupted. Grrrrr!!!

Oy vey! Databases exist for a reason, one of which is that M$ doesn't QA its office products very well.

Nice ribbon interfaces everywhere, but underneath it all lurk decades of cruft...
Inspiration, move me brightly!
 
Flighty
Posts: 7681
Joined: Thu Apr 05, 2007 3:07 am

RE: Questions About Upgrading To Office 2013

Fri Feb 01, 2013 4:19 am

Quoting Dreadnought (Reply 4):
BTW, the Office 2007 and 2010 GUI was a radical departure from the previous GUI, and it took me a while to get my bearings, but now I think it's brilliant. So maybe I am being unfair to Windows 8.

Yeah, it takes a few months to get your bearings. But in the end, it's the same good old Excel and Word.

To the OP, I don't see why you'd upgrade unless you really care about some new templates in Powerpoint, or new graph formats in Excel.

I mean, that's all it's likely to be. Functionally, Office 2010 should meet any needs you may have. Of course, Excel is not meant as a heavy database application. So, to expect those attributes is just a noob's mistake. Excel has been perfected for around 1 decade now. It's not likely to "get better" ... in fact I'd expect it can only get worse.
 
User avatar
Dreadnought
Posts: 9832
Joined: Tue Feb 19, 2008 6:31 pm

RE: Questions About Upgrading To Office 2013

Fri Feb 01, 2013 4:59 am

Quoting Flighty (Reply 10):
To the OP, I don't see why you'd upgrade unless you really care about some new templates in Powerpoint, or new graph formats in Excel.

The most important thing for me (and for the OP, it sounds like) is whether Office 2013 is more stable when using mega-sized spreadsheets.
Forget dogs and cats - Spay and neuter your liberals.
 
Flighty
Posts: 7681
Joined: Thu Apr 05, 2007 3:07 am

RE: Questions About Upgrading To Office 2013

Fri Feb 01, 2013 9:28 am

Quoting Dreadnought (Reply 11):
The most important thing for me (and for the OP, it sounds like) is whether Office 2013 is more stable when using mega-sized spreadsheets.

Well good luck to you guys, but I think you may need other tools. Excel is for manipulating and displaying relatively small amounts of data. Less than 1GB. If you need to do heavy lifting, there are tools like Access, SQL and SAS for that. Excel within its element should be pretty stable. Even if you bog it into virtual memory, if you let it calculate, it should not crash. If it does, you may have file corruption going on. 2013 or 2018 would crash just the same.
 
blueflyer
Posts: 3633
Joined: Tue Jan 31, 2006 4:17 am

RE: Questions About Upgrading To Office 2013

Mon Feb 04, 2013 4:21 am

Quoting Flighty (Reply 12):
If you need to do heavy lifting, there are tools like Access, SQL and SAS for that.

Access is one thing, but for most SQL solutions and certainly for SAS, the infrastructure and cost requirements are several orders of magnitude higher than an Excel spreadsheet, beyond the resources for most Excel power users individually.

For an Excel power user, I'd recommend loading the spreadsheet on a SSD, maxing out on memory, setting a static page file and excluding the spreadsheet from real-time anti-virus/malware checking.
Recep Tayyip Erdoğan has no clothes.
 
darthluke12694
Posts: 185
Joined: Mon Jan 12, 2009 12:47 am

RE: Questions About Upgrading To Office 2013

Mon Feb 04, 2013 5:10 am

I currently have Microsoft Office 2013. If you have any specific questions let me know and I'll try and find them out for you.

First of all, just buy Office 2013. Please don't buy Office 365. It's the same thing except you have to pay every year to use Office. I know 365 comes with cloud features, but is it worth the extra money? I don't think so.

Also, if you do plan to purchase Office 2013, make sure you install the 64-bit version. By default, it will install the 32-bit version (assuming it is a downloaded purchase of Office). To access the 64-bit version, you must click more options or something like that on the download page.

I think 2013 is generally the same at 2010 (as I had 2010 previously). The main difference is the design, which is more of the metro theme design.
KBNA - "To most people, the sky is the limit. To those who love aviation, the sky is home."
 
User avatar
Revelation
Posts: 13829
Joined: Wed Feb 09, 2005 9:37 pm

RE: Questions About Upgrading To Office 2013

Tue Feb 05, 2013 12:33 pm

Quoting blueflyer (Reply 13):
Access is one thing, but for most SQL solutions and certainly for SAS, the infrastructure and cost requirements are several orders of magnitude higher than an Excel spreadsheet, beyond the resources for most Excel power users individually.

True, but there free solutions out there proven by immense amounts of production use.

Personally, I feel if you can gain the skills to be an Excel power user, you should have no problem getting mysql set up on a machine with enough resources for it to run circles around Excel, presuming your employer can afford said machine.

Quoting blueflyer (Reply 13):
For an Excel power user, I'd recommend loading the spreadsheet on a SSD, maxing out on memory, setting a static page file and excluding the spreadsheet from real-time anti-virus/malware checking.

Very good advice.

Quoting darthluke12694 (Reply 14):
I currently have Microsoft Office 2013. If you have any specific questions let me know and I'll try and find them out for you.

Have you had any issues with file compatibility? Can you send a 2013 file around to people using 2010 or earlier without issues?

Quoting darthluke12694 (Reply 14):
I think 2013 is generally the same at 2010 (as I had 2010 previously). The main difference is the design, which is more of the metro theme design.

Interesting. Personally I don't see a reason to upgrade then. My shop just finished rolling out 2010 and new back-ends for Exchange and I don't think I'll see them push for anything to change for another several years.
Inspiration, move me brightly!

Who is online

Users browsing this forum: 727LOVER, Google [Bot], PacificBeach88 and 13 guests