J
JABU
I created a Query in Query Wizard to pull data from a SQL database and return the data to and Excel spreadsheet. I had been using this Excel spreadsheet regularly without hitch or glitch for 7 months until I updated from SQL 7.0 to SQL 2000, and something went terribly wrong
In the Excel spreadsheet, when I right click refresh data, the data does not update. When I go into the Query Wizard, the query will update but will not return to the Excel spreadsheet. I recreated the entire query from scratch in a new workbook and still had the same problems.
I have a boat load of RAM and have checked all the settings and can not figure out the problem. Any suggestions??
In the Excel spreadsheet, when I right click refresh data, the data does not update. When I go into the Query Wizard, the query will update but will not return to the Excel spreadsheet. I recreated the entire query from scratch in a new workbook and still had the same problems.
I have a boat load of RAM and have checked all the settings and can not figure out the problem. Any suggestions??