Excel 2013 sucks.

I just upgraded to Office 2013 and man does it suck.

Slow as hell, and what were the developers thinking with way the cell selection change happens? It just makes things slower IMO.

Anyone else disappointed?

Hmmm... No upgraders???

Not for me, but if you got problems with it, why should I upgrade.

Originally Posted by oeldere

Not for me, but if you got problems with it, why should I upgrade.

I would stick with 2010 0r 2007. I was just wondering if any up graders had buyers remorse? Lucky this is just on my home PC.

I don't find it especially slow but the animation is really annoying. the bi features are cool though-as long as you have pro plus version anyway

Originally Posted by JosephP

I don't find it especially slow but the animation is really annoying. the bi features are cool though-as long as you have pro plus version anyway

I hear that, I can't stand how the cells change after selecting a new one.

Apologies for the off-topic, but I, too, am a "second-version" guy. I used 2003 until 2012, when i finally upgraded to 2010, I'm "ok" with that now and probably won't see an upgrade again until Excel 2018.

I am developing an add-in for excel 2010 and started testing it in 2013 and holy crap it is really slow! I think it have more to do with protecting and unprotecting workbook than anything. For some of the code to run properly the workbook needs to be unprotected then reprotected again once it is finished, and process is way slower in Excel 2013(Ex. 1000-2000X Slower). I came up with a solution to speed up the process but it is still really Slow, but here it is anyways.

Ex. (Not proper coding just trying to convey the general idea)

State = Workstate

EnableEditing (unprotect workbook/sheets)

'do some stuff

restore to original state

You put this in each subroutine or function that make changes to the sheets or workbooks. This way if you make a call to a sub from inside one that has already enable edit it does not run the code. Once that that sub is finish it will not reprotect because of its original state before the call was made. Once the last came is make it will reprotect the workbook.

Ex.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This Code will not run, it's just the general concept. I hope this helps!

by the way if you turn off hardware graphics acceleration in the options-half the way down in the advanced section-it's much less annoying ;-)

also see this blog post: http://blog.jussipalo.com/2012/08/of...animation.html

See if http://msdn.microsoft.com/en-us/libr.../ff837594.aspx helps shed some light on this topic.

Then look at the bigger picture at http://msdn.microsoft.com/en-us/libr.../jj229830.aspx

Because the world is moving to the web, programs need to run in a browser. I believe this is motivating all software development now.

2007 was the worst of all :-)

and at last they see sense on licensing http://www.zdnet.com/microsoft-resto...es-7000012200/

I would reply to your query, but there are no canned replies any more so I can't tell you what forum rule you have just broken.

Have a nice day.

contact_ankit86...

Please do not post your questions on some-one elses thread - this is called hijacking. Please start your own thread, and if you think it it particularly relevant (I dont see how this thread would be?), post a link back to this thread

Thanks

dlmcdan

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Originally Posted by JapanDave

what were the developers thinking with way the cell selection change happens??

I don't have Excel 2013 nor have I seen it in action on anyone elses machine but...

I've seen many posts complaining about this "cell animation".

I'm not a big "bells and whistles" kind of guy so I'm sure I would hate it. I hate the way some of the right click menu items appear and then disappear in Excel 2010. WTH is this?

With that being said consider this...

Someone(s) higher up the food chain had to approve of this new "feature".

OTOH, I read that there are a "bunch" of new functions which would interest me. But, for the next couple of years I won't be "upgrading" to Excel 2013.

From what I have heard, neither will I, Tony. I currently use 2007 and have been contemplating moving up to 2010

I like the irony of your user name ;-)

I wouldnt think there is much that an i7 (3770) with 12 gig ram and 2 TB hdd would have a hard time managing?

Edit: thanks Joseph, I left out the 64bit part

unless you use 64bit having 12GB RAM vs say 4GB won't make much difference most likely. the performance dropped hugely from 2003 to 2007 in many areas and it's still playing catch up. 2013 is MUCH slower in some areas-like unprotecting worksheets-and the color schemes still suck even if there's 3 shades of white now instead of 1 ;-)
the SDI interface has introduced a few new bugs/features to keep us on our toes too

Originally Posted by TheProffesional

I like it. Mine actually operates faster then my previous excel 2010 version. Maybe its just your computer. :3

My PC build specs for my home PC.

Rampage Extreme 4 Motherboard
Intel® Core™ i7-3970X Processor Extreme Edition (15M Cache, up to 4.00 GHz)
Dominator Platinum series DDR3 2400 64GB (8X8 GB) CMD64GX3M8A2400C10
Intel 320 Series SSDSA2CW600G310 2.5" 600GB SSD
3 X Nvidia GeForce GTX 690

I look at this thread like biting the hand that feeds you. Users want more and more and more and faster, faster, faster.....

Are we showing our snob appeal by complaining about something that does so much?

Read http://spreadsheetpage.com/index.php...eed_benchmark/ for factual data about 2010 vs 2013 speed.

I wonder how many of you would go back to 2003 with less max rows and columns, no ribbon, worse pivot table features and much larger file size? How about XML type conversions? What if it was only in English instead of being localized to 47 different languages? Wouldn't you complain about that?

If we aren't careful, this tool we know, called Microsoft Excel, will simply go away and we'll be left with our social networks and slide rules to get answers.

I, for one, am very glad Excel keeps coming out with newer versions that have features that are keeping up with the world and technology.

Originally Posted by MarvinP

I wonder how many of you would go back to 2003.

I use Excel 2002 as my default version. I only use 2007, 2010 if I have to.

Marvin, excel-lent post, and a great reminder that pogress comes with a few hiccups now and then, improvements are not always perfect the 1st time round, but if there were no small steps to get better, we might still be using an abbacus (sp) and using clay tablets.

I have moved through SuperCalc, Quattro pro, lotus 123 excel 2000 - 2007, and each step has been, overall, an improvement. I admit there were times, I thought...this little part here isnt as good as "whatever"...but overall, the progressive steps have just got better and better.

What once was a very useful calculation tool, has evolved into 1 arguably of the best and most integrated tool there is around

MP, I don't mind that Excel keeps improving in some aspects, but what I wish would happen is that they do proper beta-testing and where things will be slower or non-existent, MS tells us how to work around it. For example, my first posts here (or anywhere else for that matter) was because I came across a macro that used FileSearch and it didn't work in Excel 2007. MS didn't provide advice on how to work around this problem. Today, I know there are lots of workarounds (e.g. snb's page here at EF describing workarounds for FileSearch). The point is that if MS did this upfront, users wouldn't have to keep running in circles trying to find answers to problems that were created by upgrading.

On a similar note, I just heard from the IT department that after spending an arm and a leg for an evaluation all our computer systems and calculating the true cost of upgrading from Windows XP to Windows 7 across the organization, they will be sticking to Windows XP on all systems unless you are using a tablet. There would be just too much time and money lost in upgrading/ buying new versions of programs/ hardware, etc. and even then, certain programs would stop working because there is no available upgrade.

So in short... make Excel faster (everyone happy)... make us rewrite all our add-ins (lots of unhappy clients).

abousetta

@Marvin
the notion that pointing out flaws in software is biting the hand that feeds us is honestly ridiculous. Microsoft is not going to stop making its cash cow because some people complain about its flaws but if we don't it sure as hell won't fix them (not that I am saying it will fix them even if we do-experience proves that is not always the case)

also one speed test does not prove that 2013 is faster (or slower) than 2010-although it does seem to indicate it's slower than 2003 for that test. 2013 is factually much slower in certain aspects. it's also subjectively more irritating for many due to its UI

Originally Posted by Philb1

Does it even work on a tablet?

I know it works on the Surface tablet

Nick, welcome to the forum thanks for the link, brings back memories I cut my teeth on supercalc, lotus 123 and (darn, getting old - and showing it lol - cant remember the other name now)

Yup, thats the 1 thanks

and they were all very good - in their day

Back in the day...

At work we used Lotus but at home I used QP. Then, some time in the early 90s we changed to Excel at work but I still preferred and used QP at home.

I eventually migrated to Excel in the mid 90s.

I still think that in its time QP was a better piece of software.

sounds like we followed a similar path Tony

And I can remember, back in the day when they 1st starting introducing the mouse, I bet my boss (and won) that I could do things quicker with a k/b than he could with a mouse

aaahhh those were the days LOL

Hey Guys - about 2013....

Have you tried Table Slicers yet? See http://www.youtube.com/watch?v=v4taBhc9ENQ

Also - I was looking for a way to use an external file to lookup. This file changes twice a month. It is USA Golf GHIN indexes that are updated on the 1st and 15th of each month. Player handicaps are calculated based on this changing number. In Excel 2010 they added a feature called MS Query that allows an external file to be updated and used as a reference. Excel is just getting better with more features. You can't do this with 2003 or 2007... 2013 = Better!!

Msquery has been around over a decade! ;-)

Excel is just getting better with more features. You can't do this with 2003 or 2007... 2013 = Better!!

Sooooo, ?????

How did you pass your Forum Guru exam ????

developers aren't users and by the time beta testing occurs a lot of features are usually baked in-same with most software. from what friends have told me 2013 only had the white color scheme originally-I'd flat out refuse to buy it if that were still the case; it's a migraine-inducing snowstorm

you can never please all the people all the time-the ribbon was at least based on user metrics

Since I got a new machine a few weeks ago I've decided to take the plunge and install Office 2013 this weekend.

Some things in Excel 2010 aren't exactly "works of genius". For example, the right click menu paste options.

Who the !@#$ came up with that pile of %^&* ?

When Excel went to 2007 it lost its accurate shape ability - I run my 2010 (which purportedly fixed some of the problems with shapes) with the Ribbon minimized - I expect you all do that, don't you? I was happy with my 2000 (NT5) and the NT4 prior to that. I only got 2010 because I had a gig for a 100K row file and I have it on my laptop only. Maybe MS will correct some of the annoyances of 2013 with their next edition???

Originally Posted by xladept

I run my 2010 ... with the Ribbon minimized - I expect you all do that, don't you?

I do, both 2007 and 2010.

@snb

I think we all learn what we study. We get good at problems that we solve. Excel 2013 is just another tool that has improved to where it is today. The problems have changed also with new needs to merge in data and using new tools like Slicer in Tables.

So - I was really thinking about some hard problem from the past that I've solved. Here is one for our Form Experts. This kind of problem might be why I got that GURU label.

Use any version of Excel (as a tool) to spell your own name by changing ONLY the red formula below. Here is the code:

Please Login or Register  to view this content.

Maybe we should have a GURU test!!! Should this be one of the many problems?? Arlette??

That would be a good test in that anyone who can't do it really shouldn't be a guru! I mean how hard is:

Please Login or Register  to view this content.

Rory, you are thinking about this too hard, you somethning simple like this.

Please Login or Register  to view this content.

Cool. What did we win?

Originally Posted by romperstomper

Cool. What did we win?

If I had it my way, a box of good scotch. Actually, it would be just great to have a beer with you.

I have a sneaking suspicion it wouldn't just be a beer...

Looks like it is my shout when I am in your neck of the woods then...

I look forward to it, even if my liver does not.

First look at Excel 2013.

I had to call MS tech support to get the dang thing activated.

Excel 2013 has a SHEET() function to return the sheet number but does not have a SHEETNAME() function?

Seems like an obvious complimentary function!

I like the FORMULATEXT( ) and ISFORMULA( ) functions.

IFNA( ) isolates just the #N/A errors unlike IFERROR( ) which isolates ALL errors.

The DAYS( ) function... we could've traded that one for SHEETNAME( )

That cell value "rolling effect" seems kind of cool (at least for now).

Hey Tony,

Try a VBA UDF (User Defined Function) like:

Please Login or Register  to view this content.

Also the built-in Sheet() function can return the tab/sheet number if you include the Tab/Sheet Name.

If you had a Summary sheet you could find it's tab number by doing a:

=Sheet("Summary")

I wonder how this might be included with an Indirect Function?

In previous versions I would use the XL4 macro function GET.DOCUMENT(87) to return the sheet number (for us non-programmers).

1. Create a defined name and call it SheetNum.
2. In the refers to box type:

=GET.DOCUMENT(87)+NOW()*0

3. Back on the worksheet in a cell type:

=SheetNum

Originally Posted by Tony Valko

First look at Excel 2013.

That cell value "rolling effect" seems kind of cool (at least for now).

Nevermind.

After testing with very many cells recalculating all at once this is not cool.

No, it isn't! What makes it worse is no simple way to completely disable it.

Maybe (hopefully) in the next service pack they'll have a patch that adds an option to disable it.

Based on the new style of messages you get, it should say "stop damn well jumping around"

One thing I really like about Excel 2013 is the color schemes.

I thought 2007 and 2010 were extremely "light" and hard to see. 2013 is much easier on the eyes!

I have to disagree, Biff, I cant see anything on 2013

I'm nearly blind (for real) and I can see things in 2013 much easier.

well maybe the reason I cant see 2013 to well is coz Im still running 2007 L(

Yeah, I knew you were setting me up for that line!

Yup and I knew you knew that I knew you knew

I know!

Derr,

Guess Who

Please Login or Register  to view this content.

Originally Posted by xladept

Please Login or Register  to view this content.

That is freaking brilliant. I think you may want to consider entering a contest.

@ 6StringJazzer - ah, shucks

Hi JumpBack (to 2010) Jack

See if changing some defaults does the trick. Read

http://www.accountingweb.com/article...el-2013/221223

Originally Posted by FlameRetired

Please enlighten me. What is the significance of the "+NOW()*0" part?

That makes the formula volatile so that it will recalculate if/when a sheet is added/deleted/moved.

It essentially adds 0 to the sheet number which has no net effect on the formula result.

Hi Nick and welcome to the forum,
I was reading about the comparison between Windows and Apple OS a few days ago and it seemed Microsoft had the lead. I read lots of reviews and it seem if you like pictures and music, Apple is your choice. If you want a business machine using a database then windows seems to be the choice. See the attached info for some comparisons.
http://en.wikipedia.org/wiki/Usage_s...rating_systems
http://lifehacker.com/mac-vs-windows...ents-486125257

I do not see records be dropped after 10,000. They will not appear in filter dropdown but this is not different from before.

Just upgraded to Office 2013 at work last week. Thought some of the animations were a bit annoying at first, but you get past them. Basic $500 Dell box, no bells or whistles or extreme this-or-that, and it performs just as well as when I had 2007. (Working with macros, add-ins and files with hundreds of thousands of rows.)

When the ribbon first came out many were upset, but (most) got used to that too, as with anything new. I actually like the Paste/PasteSpecial context menu. Once you know what each of the icons means, of course.

So far I've only had to change one setting (in Word) to fix a compatibility issue with a 3rd party app (merged documents were opening in a non-editable protected view), and all others just work as before.

I must be one of the lucky ones.

You are Paul. One thing I like is when writing code the intellisense actually works.

Still sucks, no avoiding it.

Just upgraded to Excel 2016 and things have not gotten any better.....

you oughta try 2016 on a mac. worst thing I've seen for a long while

Yeah the animations in 2013 anoyed me too so I googled how to turn them off

Please Login or Register  to view this content.

Note: Changes don't take effect till you compleetly close out and re-open excel, and you can tell if animations are on or off by copying a cell. The ants don't march if animations are off.

Isn't it time for a "Excel 2016 sucks" thread?

Originally Posted by 6StringJazzer

Isn't it time for a "Excel 2016 sucks" thread?

I could do that.