Editing Microsoft Excel files online could finally get a lot simpler

Microsoft Excel for the Web can now open and edit more files than ever

When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.

Editing spreadsheets on the go or at work should soon be easier than ever thanks to a significant update to the web version ofMicrosoft Excel.

Microsofthas revealed a number ofspreadsheet softwareupgrades that it says will help close the gap with its desktop-based sibling, including better support for larger files, as well as those with legacy features.

“We are excited to share that you can now open and edit more files on the web and complete your job anywhere, in the browser of your choice,” Microsoft noted in an Excelblog postannouncing the news.

Excel for Web upgrade

Excel for Web upgrade

Going forward, Microsoft Excel for the Web will now allow users to open and edit large files from SharePoint up to 100MB in size. This will expand possible files to thousands of rows of data, and means users will not have to switch to the Desktop version of Excel to finish work.

Users can also now edit files containing what Microsoft calls Legacy Art objects and SmartArt objects - including the likes of Form Controls, ActiveX Controls, Camera Tools, and OLE objects. The company says this will allow users to access and interact with any such workbooks but not with the objects themselves.

Elsewhere, users can now also access password-protected workbooks on Excel for the Web, meaning there’s no need to switch back to a desktop in order to open & interact with secured files. Similarly, users can now also edit files which are protected for editing using a password to modify, meaning you’ll be able to access and interact with different types of protected workbooks on the browser itself.

That’s not all, as Microsoft also noted that more features will also be added soon, including support for Microsoft 365 subscribers to edit large files up to 100 MB from OneDrive, and further support for editing workbooks with legacy shared features and data wizard connections.

Are you a pro? Subscribe to our newsletter

Are you a pro? Subscribe to our newsletter

Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!

The news comes shortly after Microsoft revealed it will be bringing support forsmoother scrolling to the Excel Desktop app, hopefully resulting in a much better user experience.

Mike Moore is Deputy Editor at TechRadar Pro. He has worked as a B2B and B2C tech journalist for nearly a decade, including at one of the UK’s leading national newspapers and fellow Future title ITProPortal, and when he’s not keeping track of all the latest enterprise and workplace trends, can most likely be found watching, following or taking part in some kind of sport.

7 myths about email security everyone should stop believing

Best Usenet client of 2024

Smeg Combi Steam Oven review: a multi-functional countertop oven that looks stunning and cooks well