Excel Desktop vs Excel Online - online version should have all/most of the same features
There are several functions that don't work the same in the online version vs desktop. Below are a few that are particularly frustrating to me so far:
~ Paste/Formatting - When pasting into the online version, the format doesn't stay.
~ Sorting - There are very limited sorting options in the online version.
~ Copying data. I have about 300 lines of data that's about 10 columns wide and am unable to copy it so that I can paste it into another document and sort it the way I need (since online version has limited options for sorting, as mentioned above). I get the following error when I try to do so: "The data you've selected is too large. Try selecting a smaller set of data."
Michael Hutchens commented
Most of these comments are just scratching the surface. If you ask the Excel team they'll tell you that the online version is light years away from the desktop version, purely because building browser-based apps is a nightmare compared to having the control of a desktop app. In many regards, I'm amazed how well Microsoft has done, even though I agree that ideally Excel Desktop and Excel Online should be identical.
My biggest issues with Excel Online is that some common workbook features - like comments, shapes and controls - cause the workbook to open in read-only mode in Excel Online. These features have effectively rendered Excel Online useless to most of our clients, which is why we recommend not using it.
We could theoretically build all our models avoiding these features, but it really should not be an issue in the first place.
So, in summary, I vote passionately in favour of this improvement suggestion.
Excel Online = Epic Fail. Put it out of its misery, so it creates less misery for users.
All it's doing is cheapening the Excel brand, and giving Excel critics an easy opening.
Many users wants to Edit an Excel file with feature which are not supported in Browser. would be great it it supports over browser too!
Functionality of excel on line is really terrible. How on earth is it possible that it's released?? Sorting, pivot tables, speed ..... I Always have to open excel in the desktop to work properly. Very bad product/service
With everyone saying the same thing, you'd think maybe they would let us know if there will ever be an update to the online version so it's the same as the desktop version. What alternatives are out there?
I hate the fact that these simple applications such as the changing the New Cell Style is only available to the desktop computer. I am trying to get my assignment done and yet I cant because of no options such as these it makes no sense to me its ridiculous. Some how I have to find some other alternatives to complete my assignment I hate how you people limit the use of your application online
Mason McClure commented
Online needs all the features that the desktop provides very limited for Excel Online
I have used the MS gantt template. On desktop, looks great but online some formatting has disappeared so
I now have ‘blank’ bars and it looks awful. Why?????????
it is good for people that use excel for grocery lists
Yes it is terrible. I am very angry with myself that I bought a chromebook instead of a laptop with a microsoft OS since I can barely do anything on it properly.
@kt: Right??!!! Can't even change the tab name FFS! Uggghhhhhh I hate SharePoint Online. I hate Word Online. I REALLY REALLY REALLY HATE Excel Online. I hate that uppn clicking on a link to the doc, any Online version of an application opens in Edit Mode if you have edit access. This then "saves" your NON-EXISTANT changes.
Which screws with your historical governance from an audit perspective.
And since all features that are actually useful are not available in Excel Online, one is forced to open in the app. But doing so to edit, locks the document every single time. So the Collaboration Editing "feature" is not actually available.
Honestly. I hate MS. If and when I run a business, I vow to never ever ever use MS product suite.
Thanks for allowing me to vent peeps. Lol
I agree, i cant even change my page orientation, scale, or set up print preview on the workbook screen!!!!
@Same and @Tim Sullivan: Exactly!! So much! I know you have different comments but I whole heartedly agree with both of you.
Also, it truly is mind boggling that MS thinks their Excel Online is a viable product. Do people actually use Excel as a home product all that often?? When there are now free programs that can do the same as one would use Excel for, for personal use? I doubt it.
MS: your Excel clients and users are people in business. Excel Online literally excludes all of the most useful functionality that a person using it for business needs. It is embarrassing. Make Excel Online the same as the desktop version or stop focusing on it until you can. It literally hurts my soul. And my brain. And my overall health. In fact your whole "Online" suite is likely to make me have to go on stress leave. Seriously. SharePoint Online, Excel Online, Word Online, every one just introduced a new horror to contend with. Get your sh*t together MS
i like so much tank you you are help me so muvh i don't have world to say this think you know
open this file
hello how are you doing
Ribbon Customization & Sheet Protection with same features as Excel Desktop is required else the administration of the file becomes very difficult if multiple users are working.
+/- to zoom in and out to resize the workbook
Tim Sullivan commented
If Excel Online is not going to be the same as Desktop, just rename Online to Excel Works. Just like the old 1990's home products that didn't satisfy the user..
The Cloud is a MAJOR work avoidance and hindering efficient working.
The last few years of Office products are a productivity disaster