|I have built an excel sheet for data imported from a stock market website. However, I have concerns:|
1. I do not know how to set the excel file to automatecally update every one hour/four hours/ one day...etc.
2. I do not know how to update the file when it's protected by a password. In other words, the file can't be updated (import latest data from web) when it's protected. it's essincial to solve this issue without having the formulas revealed.
Could you please teach me how to solve these two issues?