george1234
New Member
- Joined
- Oct 5, 2006
- Messages
- 2
I have some xls sheet that contain queries to a SQL database.
I find that sometimes when i refresh the query, the query breaks/dies after the data has been pulled from SQL. What I mean is that I am no longer able to refresh the query.
I am left with the need to create the query again. I do not know why this happens although it seems to have something to do with whether i have re-calculated all data in the spreadsheet prior to refreshing the data. Also it seems to happen less for queries that do not have formula column within the query output columns and/or formulas in columns adjacent to the query output columns.
Has anyone run into this problem? How can I stop this from occurring?
I find that sometimes when i refresh the query, the query breaks/dies after the data has been pulled from SQL. What I mean is that I am no longer able to refresh the query.
I am left with the need to create the query again. I do not know why this happens although it seems to have something to do with whether i have re-calculated all data in the spreadsheet prior to refreshing the data. Also it seems to happen less for queries that do not have formula column within the query output columns and/or formulas in columns adjacent to the query output columns.
Has anyone run into this problem? How can I stop this from occurring?