Automatic update + update a protected file

Microsoft Excel 2010
May 25, 2011 at 17:50:05
Specs: Windows 7
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?


See More: Automatic update + update a protected file

Report •


#1
June 4, 2011 at 17:38:53
any help please

Report •
Related Solutions


Ask Question