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.
Bookmarks