Link to home
Start Free TrialLog in
Avatar of Aries Polestico
Aries Polestico

asked on

Disable auto refresh in a sheet

Good AM gowflow,

       I just tried it in a large file. It always auto refreshes every time I open the sheet "data" and it takes 30 to 50 seconds to finish refresh. Is their any alternative solution so that it will not auto refresh every time I open the sheet data? That if I click the command button "refresh" that's the time the refresh event will be activated. Please refer to the file that you sent to me yesterday because the sheet data also is in auto refresh every time I open the sheet "data"
Macro-Test-V01.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aries Polestico
Aries Polestico

ASKER

Thanks for the solution wayne.