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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER