Microsoft’s Excel for the Web adds support for editing large files and legacy files

Over the past few years, Microsoft has continuously added new features and enhancements to Excel for the web. Today, Microsoft announced a number of new features and improvements to bridge the gap with the Excel desktop app. Some of the new features include support for editing large files, support for editing files with legacy objects, the ability to open password-protected workbooks, and more. Find the full change log below.

Supports large files from SharePoint up to 100 MB

You can now open and edit large files from SharePoint up to 100MB. This allows you to work with thousands of rows of data and compete with your work without having to switch to Desktop.

Edit files with Legacy Art Objects & Smart Art

You can now edit files containing Legacy Art & SmartArt objects in Excel for the Web. These legacy art objects include Form Controls, ActiveX Controls, Camera Tools, and OLE objects. This allows you to access and interact with any such workbooks, but not with the objects themselves. If you are using the Button Form Control / ActiveX Control to run the macro, check The Office Scripts function allows you to run office scripts using the workbook button.

thumbnail 1 captioned Image: Workbook with Legacy Art & SmartArt ObjectsImage: Workbook with Legacy Art & SmartArt Objects

Open and edit password-protected files – Rolling Out

Password protected files to open

You can now access your password-protected workbooks on Excel for the Web. This allows you to open and interact with your password-protected files to open without switching back to the desktop. Note that co-authoring is not supported with password protected files (same as Excel Desktop). We recommend switching to the new Microsoft Information Protection encrypted workbooks that allow you co-author and still protect sensitive data.

thumbnail image 2 captioned Image: Password protected workbook (Password to open)Figure: Password protected workbook (Password to open)

Password protected files for modification

In addition to the above, you can also edit files that are protected for editing with a password for modification, thus allowing you to access and interact with different types of protected workbooks within the browser itself. Browser. Note that co-authoring is not supported for Passwords to modify (same as Desktop), we recommend share editing access to specific people allows you to block editing for others.

thumbnail image 3 captioned Image: Password protected workbook (Password to modify)Figure: Password protected workbook (Password to modify)

Coming soon

In addition to the features above, the following features will be available to Excel for Web soon:

  • Supports large files up to 100 MB from OneDrive (M365 subscribers only) in Excel for Web, thus allowing you to work with large data sets in the browser.
  • Edit files with the presence of the legacy shared workbook feature, by giving you the one-click shutdown of the legacy feature, thus allowing you to interact and collaborate with workbook.
  • Edit a file that contains legacy data wizard connections such as Text Queries, Web Queries, Query Tables, or SharePoint Lists, thus enabling interaction with the workbook. We have no plans to support the connection itself and recommend switching to Import data via Power Query to connect and refresh data.

Source link Microsoft’s Excel for the Web adds support for editing large files and legacy files



from Inter Reviewed https://ift.tt/3DuJ63d
via IFTTT

Comments

Post a Comment

Popular posts from this blog

Best Minecraft texture packs for Java Edition in 2021

Image
On the lookout for one of the best Minecraft texture packs for the Java Version? Minecraft’s low-fi charms had been predictably the very first thing modders took to ‘fixing’. The ruddy textures, whereas distinctive, are an apparent goal for an improve in case you stare at them lengthy sufficient. Whereas Mojang has been regularly revamping the aesthetic attraction of Minecraft, significantly with the introduction of Minecraft Ray Tracing , in case you’re chasing a particular look then texture packs are your finest wager. Right here, we’ve included our favorite Minecraft texture packs. There’s nothing too loopy in right here, as large visible overhauls are typically a part of bigger Minecraft mods that essentially change the sport, and that’s one other article completely. What we now have here’s a improbable choice of texture packs that give Minecraft altered visible types, from the ultra-realistic to the cartoonish, to far out sci-fi and refined makeovers. There’s even animated tex
Read more

A+ by A bank APK 1.2 (Android App)

A PLUS – the latest all-in-one e-wallet and mobile banking app from bank A. Securely top up your phone, send money to anyone, pay bills and more within a few seconds. Download and sign up today with just your name and phone number! Highlights • Enjoy signup rewards and refer friends to A PLUS for more rewards for you and your friends • Free for making app transactions in A bank and A PLUS network • Cash conveniently into both your wallet and bank account(s) at any of our agents or branches Recharge: Recharge any mobile operator’s balance Pay the bill: Pay all your bills directly from your wallet/account to the biller with just the biller ID Cash withdrawals: Deposit and withdraw with your A PLUS at a nearby dealer or bank branch Transfers: Transfer funds between your own A PLUS accounts, to another A PLUS account/wallet, or to anyone using just the recipient’s name, phone number and NRC Pay and claim money by QR code: Enjoy paying with QR codes at our restaurants and par
Read more