• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Refresh All

AAP

AAP

Member
Hi,
I am wondering if I click on refresh all under Data tab, does it refresh all open workbooks or only the workbook that I used to click on refresh all button?

Thanks

Regards/Amit
 
You can do that with a small piece of VBA Code

Code: 
Sub Refresh_All()
Application.Calculation = xlCalculationAutomatic
ThisWorkbook.RefreshAll
End Sub

You can assign that to a Button on the worksheet or QAT icon if required
 
Hui said:
You can do that with a small piece of VBA Code

Code: 
Sub Refresh_All()
Application.Calculation = xlCalculationAutomatic
ThisWorkbook.RefreshAll
End Sub

You can assign that to a Button on the worksheet or QAT icon if required
Click to expand...
Thanks Hui,
My question was not VBA code. I want to understand that refresh all button refresh one particular workbook or all other open workbooks all together.
 
You must log in or register to reply here.
Back
Top