Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
harriettbird
 
Posts: n/a
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
enable automatic refresh Vass Excel Worksheet Functions 2 March 11th 06 04:36 AM
Disable Query Refresh warning dialog box in Excel 2003 Jeff Koons Excel Discussion (Misc queries) 2 December 1st 05 04:08 PM
Excel 2003 - New Database Query JNA Excel Discussion (Misc queries) 0 August 17th 05 10:01 PM
New web query with Excel Pro Edition 2003 Chandler Links and Linking in Excel 2 December 15th 04 06:03 PM
open saved query in Excel 2003 jaylou Excel Discussion (Misc queries) 1 November 29th 04 06:41 PM


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"