A
alderran
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.
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.