Excel fans (yes, it takes everything to make a world) will be able to use a new method to automate their workbooks. The roadmap for Microsoft 365, the subscription to the cloud version of the office suite, indicates that Office scripts will appear on Mac and PC spreadsheet clients starting in October. This function was previously reserved for the online version of the software.

Power users of Excel did not wait for this announcement to embark on automation: there are indeed VBA macros, which have been with them for a long time. But while Office scripts serve the same purpose, they were originally developed for cloud solutions starting with Excel on the web.

The advantage of Office scripts over VBA macros is that they can easily call on online resources and with other web services. VBA was designed to interact primarily with the user’s computer

How to Recover Unsaved Excel File on Mac?

Benefits of 4DDiG Data Recovery:

  • Recover all lost data and recover from all Mac devices including USB, SD card, digital camera, etc.
  • Recover 1000+ file types, such as photo, video, audio, Microsoft Offices, Zip, email, etc.
  • Safe – 100% safely recover deleted files on Mac with high success rate.
  • Easy – Just 3 clicks to recover data. No need to disable SIP.
  • Fast – Quickly scan and recover your files.

How to Recover a Microsoft Office File You Forgot to Save

You are working on a spreadsheet Excel, to check and recheck that your figures are correct, everything is going well. You are a machine, nothing can prevent you from carrying out your task and impressing your boss. Except, perhaps, a power outage that shuts down your PC before you can save your file. Either you start all over again, or you quit your job without looking back.

Recovering a Microsoft Office file that has not been backed up is quite easy

While it’s never a good thing not to save your work, losing a document like this isn’t the end of the world. If you accidentally closed an Office file without saving, you don’t have to worry about having to start all over again. There’s an easy way to recover the file, using a recovery tool built right into the Office application you’re using.

When working on a Word, Excel or other document, the file is not saved only when you click the “Save” button. The app in question has your file data in a separate folder within your user account’s AppData folder. This folder, out of sight of most users, saves data for many Windows apps for your user account.

Office has a dedicated recovery tool

In most cases, an unsaved and recently closed Office file can be found here. There are two ways to find it. The first, the simplest and most direct, takes you directly to the folder in question that contains the lost document. To do this, open the app used, click on the File tab at the top left and choose Info. Now click on “Manage Document”, then “Recover Unsaved Documents”. There you should see the file you closed without saving. Select it, click on “Save as” to never lose it again.

If you want to play it a bit more techy, there is a somewhat more advanced method to achieve the same result. Press Windows + R to open the “Run” window. There, type “%appdata%” and run to open the folder that interests us. From there, navigate to your app’s folder (for example, the Microsoft folder and then the Word folder). This is the folder that you directly open in the first method. You should find your file. Open it and save it.

Excel users on Windows and Mac will soon be able to automate repetitive tasks,

Excel users on Windows PC or Mac will soon be able to automate many tasks in their spreadsheet, a feature that is currently only available to those using the web application. The new Microsoft 365 Roadmap entries indicate that starting in October, users will be able to create, edit, and run scripts to automate these tasks using the Code Editor and Task Map” All Scripts”. Microsoft said the goal of automating tasks in Excel is to improve user productivity.

However, Office Scripts, a set of automation features, is currently limited to Excel for the web. That will change next month, as Microsoft promises to bring it to more platforms, namely Mac and Windows. According to the Microsoft 365 roadmap page, Excel users on Mac and Windows will be able to automate their repetitive spreadsheet tasks.

They will be able to create, modify and execute scripts in Excel for Windows and Mac using the code editor and the “All Scripts” task pane, just like with Excel for the web. The ability to create, edit and run Office Scripts in Excel would be very useful, especially in workplaces. You can easily automate your daily tasks, without worrying about forgetting steps. The goal of automating tasks in Excel is to improve productivity, not only for the individual user, but also for others in the Microsoft 365 universe.

Theoretically, automation done by one user can be used by others, although everyone has their preferred way of doing things. Users can record what they have done with “Action Recorder”, which creates a script in TypeScript language that can be run again when needed.

“Scripts allow you to record and replay your Excel actions on different workbooks and worksheets. If you find yourself doing the same things over and over again, you can turn all that work into an easy-to-run script. Run your script at the press of a button in Excel or combine it with Power Automate to streamline your entire workflow,” Microsoft explains. According to the roadmap page, the automation feature set will first be available in preview in October. General availability could arrive the same month.

While unconfirmed, a preview of the automation feature set will likely be available to Office Insiders subscribers early next month. And a wider rollout could happen in mid-to-late October. However, Microsoft could change its plans. Enabling Office Scripts for Excel on Windows and Mac is one of many efforts Microsoft is making in hopes of expanding the reach and usefulness of the spreadsheet program, which has more than 750 million users.

Categorized in: