ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Query and Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/86645-ms-query-excel-2003-a.html)

harriettbird

MS Query and Excel 2003
 
I am working with 2 clients who are both using WinXP/Office 2003 SP1. They
have database queries which go to a SQL server. Sometimes the queries update
as they should. Other times only some sheets will update. This is very
sporadic. When the sheets don't update it is because Excel has "lost" the
query - the options on the database toolbar are all grayed out. If the file
is closed without saving and reopened - the queries are still connected and
will usually run fine. They never had any problems with their queries while
using Win2K/Office 2K. Has anyone else experienced this problem? Any
suggestions?


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com