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."
christian boes commented
how can i print out e-mail from george wu ???
please send it to <email@example.com>
I always click 'Open in Desktop App' because the online functionality is so limited. That means the investment in the online version is (from my point of view) a waste of money so far...…...
I can't open most of my Excel files with the Online version because the files are too large.
Feed Back Excel Online Limitation: I get the following error when I try to open an excel file using Excel Online
Couldn't Open the WorkBook " Sorry, we can't open your workbook in Excel Online because it exceeds the 30 MB file size limit. You will need to open this in the desktop app..
Filters: opening XLSX files from our Sharepoint always opens them in Online, but I can't use filters on the columns of data so I have to click through to the Desktop version. There are rudimentary filter function in Online, but not sufficient and very different from functionality of Desktop. I'd appreciate better filter functions in Online, please.
je n'arrive à utiliser le Excel
Luis Antonio commented
Hello, it would be of great help for corporate issues that re-integrate the 3D maps function in excel online since when removing it they also left no alternative to continue visualizing them, working them or creating them.
I am so glad I am not the only one complaining about Excel online. Judging from the comments on the page it is not good enough to be called Excel. It reminds me of that bank commercial that states it is wonderful you can get snacks and coffee in addition to banking. Well if all you have is a checking or savings account you may think that is banking. Believe me it is not a financial institution should be able to provide comprehensive money management across multiple arenas.
Michelle Antonie commented
Please focus on developer options. Macros should be usable online. Not having these usable in the online version make the files useless.
Adminexcelonlineteam (Admin, Office.com) commented
Thank you for your feedback we highly appreciate it and happy to share our related progress.
Copy & Paste:
We have made great progress in Copy and Paste between two web workbooks, you can now copy formatted Text, formulas, conditional formatting, data validation rules and hyper links, etc.
Soon will be released to production copy and paste of formatted text to and from Excel Online.
We are considering increase of copy & paste size.
Please check out our recent improvements in Multi level sort in Excel for the Web.
Coming soon to production sort by Colors and Icons.
Within a excel-cell, highlighting 1, 2 words using the bold, italic or underlined options, doesn’t unfortunately work. In both the web and app versions of Moveoffice-Teams, the highlighted words are not highlighted, but always the entire text within the cell ... The same is true for color tags ... When will it work?
I didn't know I would need to buy desktop version as well as online version to get all functionality. Just starting and cannot sort list in online word. Cannot format print document in excel. bummer. :(
the online versions seems doesn't have go to special feature
I'd say there are at least 100 features I'm used to using that plain out don't exist in this loser version of Office Online. Excel Margins. Can't adjust margins. WTF? Is this 1992 or something? And because its free, my computer doesn't have a "desktop version". So MS justifies this crapware cause the user can just open desktop. But mine is to cheap so there is no desktop. The previous suer of the computer instaled Libra office, but that' sbroken now. One co-worker does all his work in Google Drive and then converts. We can't share files cause Excel Online Loser Version won't open everything, inlcuding documents created in Excel Online Loser Version!
Tabs in Word. Tabs? Heck, I could write my own Word replacement that supports the .docx format and tabs would be one of the first features to implement. No tabs?!?
Agree. Copying data is terrible. 100k size is not enough. I always get that error you describe.
Arline Acevedo commented
Can't edit text boxes or create them. Kinda really sucks when I'm away from home and I want to work on my small laptop.
maheswari mahe commented
please open the files
harun ur rashed commented
John Bennett commented
It's really that simple Microsoft. All we want is for everything to work in both offline and online programs. So I do not know why you have a voting poll. Just make sure both environments function exactly, then we will all be happy. Thank you.
Harselina Riung commented
control/command select shortcut to highlight non adjacent cells, rows and columns for online version