i creat a excel ,several sheets. i wanna when i change one of sheets,the others can refresh at the same time,but in fact ,i found some can work ,some not ,in this case, i must click it ,refresh it again,than it can be work.why and how can i deal with this question.thanks!