LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default disappearing querytables

I created an add-in that allows users to embed calls to a database for
financial information. It uses querytables in the workbook. I have a user who
ends up from time to time with a workbook that will no longer connect to the
database.

It's only the one person. No one else reports having this problem. So I'm
guessing it is either the users computer or the workbook itself. She is the
only one using that particular workbook. I checked to see if she might be
deleting the querytables, but she claims that she refreshes the sheet and
then the links are gone. When this problem comes up we just get the file
restored. So it's always the same sheet.

I am unable to recreate the problem on my computer. The end user has Excel
2003 and I have Excel 2007. I'm currently in the process of installing MS
Virtual PC so that I can load a copy of Office 2003 on Windows XP, but not
really that hopeful because most of the users have this same setup and this
is the only problem child.

Any help would be greatly appreciated.

 
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
QueryTables Tomo Excel Programming 1 June 3rd 08 04:33 AM
QueryTables.Add and XML Sönke Schreiber Excel Programming 0 September 20th 06 11:43 AM
QueryTables command Sharlene England Excel Programming 0 January 4th 06 11:43 PM
QueryTables Add Marta[_3_] Excel Programming 0 January 19th 05 05:32 PM


All times are GMT +1. The time now is 05:14 AM.

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

About Us

"It's about Microsoft Excel"