Next i Sub Progress Meter() Dim boo Status Bar State As Boolean Dim i Max As Integer Dim i As Integer i Max = 10000 Application.Screen Updating = False ''//Turn off screen updating boo Status Bar State = Application.Here are some links to people who have also noticed this problem: 791577-Application-Screen Updating-not-working-in-Excel-2013 https:// test the difference in screen updating, try running the one-and-only macros in these files: first file does not use Application. Adding Do Events, which normally makes Excel responsive while a macro is looping, does not help either situation.Status Bar = Format(fraction Done, "0%") & " done..." ''// or, alternatively: ''// status Range.value = Format(fraction Done, "0%") & " done..." ''// Some code....... Display Status Bar = boo Status Bar State ''//Reset Status bar display setting Application.Status Bar = False ''//Return control of the Status bar to Excel Application.Step 1: Create the table in Excel The first step is to create the table of data in Excel so that it looks exactly the way you will want it to look on the slide, including titles, row labels, column labels, gridlines, text and background colors and text formatting.Step 2: Copy the table in Excel Using your mouse or arrow keys, highlight the table of data in Excel. The slide layout with a title only is usually a good choice if the imported table will be the main focus of the slide.

It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).

But the screen doesn't refresh, or stops refreshing at some point (e.g. The task eventually completes but the progress bar is useless. For i=1 to imax ' imax is usually 30 or so fraction Done=cdbl(i)/cdbl(imax) Application.

Status Bar = Format(fraction Done, "0%") & "done..." ' or, alternatively: ' status Range.value = Format(fraction Done, "0%") & "done..." ' Some code.......

Quick Jump Introduction | Example | Tutorial | Applications | Comments Prevent your screen from updating until your Excel macro is finished with Application. It can be used for other applications, but I find it most useful for Excel.

Screen Updating property is useful when running macros that jump from cell to cell, sheet to sheet, and workbook to workbook. Screen Updating to False stops your screen from flickering (refreshing) as your macro runs.