Technology

#How to Optimize Workbook Performance in Excel for the Web

“How to Optimize Workbook Performance in Excel for the Web”

Microsoft Excel logo on a green background

In Microsoft Excel on the web, click the “Review” tab on the ribbon and click “Check Performance.” Click the big “Optimize All” button to apply all the suggested optimizations to your entire workbook.

When you use Excel on the web, do you notice that your workbook takes a long time to load? Microsoft seeks to help you solve this problem with Check Performance. Here’s how it works.

With Check Performance, you can see empty cells in your workbook that contain formatting, whether visible or not. You might have had data in these cells at one time. Even though that data is now gone, the formatting remains and adds to the size of the workbook. This can cause a slowdown in performance.

Note: As of September 2022, the feature is available to Microsoft 365 subscribers using Excel for the web.

Check the Performance of an Excel Workbook

Visit Excel on the web, sign in, and open the workbook you want to review. You may see a message in yellow at the top encouraging you to try out the feature by providing a link. But you can access it manually too.

Go to the Review tab and select “Check Performance” in the ribbon. This opens the Workbook Performance sidebar on the right.

Check Performance on the Excel Review tab

At the top of the sidebar, you’ll see how many cells are used and the number of cells to optimize in the workbook.

Cells used and to optimize in Excel for the web

You’ll then see a list of the sheets containing empty cells that can be optimized. Hover your cursor over the information icon (small letter “i”) next to Review by Sheet to see the total.

Total sheets to optimize in Excel for the web

You can then select each sheet to view the cells if you like. You’ll see which cells can be optimized using the cell reference(s). You’ll also see the type of formatting to remove in the cell, including things like number formatting, text properties, and fill color.

List of optimization suggestions for a Excel sheet

Click the cell or cell range in the box to highlight those cells in the sheet if you want to review them.

Cells highlighted for performance

Optimize the Cells in a Workbook

You have a few ways to optimize the sheets and cells you see in the sidebar. Microsoft allows you to control how you remove the formatting (if you want to).

RELATED: How to Clear Formatting in Microsoft Excel

Optimize the Workbook

If you want to optimize the entire workbook in one fell swoop, this is the simplest option. With the Workbook Performance sidebar open, click “Optimize All” at the bottom.

Optimize All button for a workbook

Optimize the Sheet

If you prefer to review each sheet and optimize them one at a time, this is another option. Select a sheet from the list in the Workbook Performance sidebar. Then, click “Optimize Sheet” at the bottom.

Optimize Sheet for a sheet

Manually Change the Cells

One final option is to manually remove the formatting from the empty cells. Start by selecting a sheet in the Workbook Performance sidebar. Then, click the cell reference or range in the box to highlight the cell(s) in the sheet.

RELATED: How to Remove Table Formatting in Microsoft Excel

Since you can see the formatting that’s contributing to how the workbook performs, you can then remove that formatting from the cell(s) yourself if you want.

An easy way to do this, especially if the cell(s) contains several formatting types, is to go to the Home tab and select the three dots on the right side of the ribbon for More Options. Move your cursor to Clear in the Editing section and pick “Clear Formats.”

Clear Formats in the More Options menu

You can, of course, use your own method to remove the formatting if you prefer.

As you optimize the workbook, sheets, or cells and make changes to your workbook, the Workbook Performance tool updates. So, you may see a message in the sidebar to recheck the workbook. Click “Check Again” to run the performance test after you make changes.

Check Again after the workbook changed

When the file size of your workbook grows over time, it can take longer to load in Excel. Being able to see what improvements you can make to optimize the workbook is a handy feature to keep in mind.

Be on the lookout for this Check Performance feature to arrive in Excel for Windows and Mac in the future.

If you liked the article, do not forget to share it with your friends. Follow us on Google News too, click on the star and choose us from your favorites.

For forums sites go to Forum.BuradaBiliyorum.Com

If you want to read more like this article, you can visit our Technology category.

Source

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
Close

Please allow ads on our site

Please consider supporting us by disabling your ad blocker!