Is worksheet 100% refreshed

S

sime

Hi All
This is a repost of a previous question. FWIW original post here:
http://groups.google.com.au/group/m...el.programming*&rnum=4&hl=en#d03d34661710c27d

I have worksheets that have "EnableCalculation" = False. They don't
need to recalculate unless the user changes a value.

However, when I force them to calculate I can't seem to guarantee that
a full refresh will happen before calculation is disabled again.
Here's my code:

With ThisWorkbook.Worksheets("MyReport")

.EnableCalculation = True
ThisWorkbook.RefreshAll
.EnableCalculation = False

End With

What happens is, if the user clicks the sheet, the refresh is delayed.
But the code continues to turn off calculation.

So, I want to change my code to the following, but I cannot find the
exquivalent of (the fictitious) "Workbook.NeedsRefreshing":

With ThisWorkbook.Worksheets("MyRep­ort")

.EnableCalculation = True
ThisWorkbook.RefreshAll
While ThisWorkbook.NeedsRefreshing = True
Msgbox "Please wait for the report to refresh."
ThisWorkbook.RefreshAll
Wend
.EnableCalculation = False

End With


A solution would be very much appreciated.

Kind Regards
Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check if workbook is waiting to calculate 3
Auto Refresh Pivot Table after Source Data is Refreshed 0
Excel2000 VBA: How force the procedure to wait until queries are refreshed? 2
Merged cell auto row height revisited 3
Run-time error '5' when I add code to allow filtering on protected sheet. 4
Excel is Waiting for another Application to complete OLE Action 6
2007 Ribbon control disabled by Excel when sheet is protected -Override with getEnabled? 9
Find/REplace from table questions... 2

Top