Calling the issue a number of excel
I would like to set up more than 1 EXCEL spreadsheet data call each other, but taking into account the EXCEL will be very slow to update the data, there are ways to speed up the call? If you do not have to speed up the database can call ah.(A total of 13 EXCEL, which each have 10 Around the table, 13 sets of forms, or call each other between the level of the call)
prepared to take a few formulas.
At the same reason and a check with several different forms.
It should be noted that after the formula for the location and name of the file can not be changed.Do not know the relationship between form, you people how to answer it?
EXCEL be able to use SQL Query statement, the speed is not a problem.
Your table-mail sent to me, I try!
Hjf87306@sina.com read your mail inside
things you can be prepared Table 1 formula bar in the aggregate data to the 2, Table 2 in the data in aggregate form to 3; If you want to view the data in Table 2, to open a direct, will be able to update, but if you look at Table 3 The data must first open the table to open in the end update 2 Table 3, Table 3, or else the data will not change.
In addition, the name of the table can not be changed; sheet can be the name of, but There is a condition, such as table 2 data through the formula from Table 1 of sheet1 achieved, then the change in Table 1 in the name of the sheet1 must ensure that Table 2 is open, otherwise, could not find the time to open the next path, No more lines.
Would like to help you
Leave a Reply
You must be logged in to post a comment.