F
Fredrik
I have a number of spreadsheets which use Ms Query to retrieve data from an
Oracle database. I have set it up so that queries run automatically when I
open a spreadsheet.
In Excel 2003, if I open several such spreadsheets at the same time, Excel
will open all spreadsheets first and then run the queries. This means that I
can open all the spreadsheets I want to update, get immediate notification if
any one of them is in use by someone else, open as read-only if so, and then
go off and do something else while all queries update (15-20 minutes in some
cases).
In Excel 2007 when I try to do the same thing, Excel opens the first
spreadsheet, runs all queries on that spreadsheet, then opens the second
spreadsheet, runs all its queries, opens the third spreadsheet, and so on.
This means that I have to wait for the first spreadsheet to open and its
queries to update before I know if the second spreadsheet is in use and needs
to be opened as read-only.
Is there a way to force Excel 2007 to open all spreadsheets before it starts
updating queries?
Oracle database. I have set it up so that queries run automatically when I
open a spreadsheet.
In Excel 2003, if I open several such spreadsheets at the same time, Excel
will open all spreadsheets first and then run the queries. This means that I
can open all the spreadsheets I want to update, get immediate notification if
any one of them is in use by someone else, open as read-only if so, and then
go off and do something else while all queries update (15-20 minutes in some
cases).
In Excel 2007 when I try to do the same thing, Excel opens the first
spreadsheet, runs all queries on that spreadsheet, then opens the second
spreadsheet, runs all its queries, opens the third spreadsheet, and so on.
This means that I have to wait for the first spreadsheet to open and its
queries to update before I know if the second spreadsheet is in use and needs
to be opened as read-only.
Is there a way to force Excel 2007 to open all spreadsheets before it starts
updating queries?