Our Clinical Fiscal Manager is having issues with data connections being dropped when she refreshes a worksheet. She has a very simple data connection which she copies and modifies for to return data in another worksheet in the same book. She then pulls the data into the spreadsheet and saves the workbook.
\When she reopens new worksheet, she gets the following error
<?xml version="1.0" encoding="UTF-8"
standalone="true"?>
-<recoveryLog xmlns=" http://schemas.openxmlformats....../2006/main "><logFileName>error009240_01.xml</logFileName><summary>Errors
were detected in file '\\INSIDE\Clinic\Billing\Wrap Around\Wrap Data
Pull.xlsx'</summary>-<removedParts summary="Following is a list
of removed parts:"><removedPart>Removed Part:
/xl/queryTables/queryTable1.xml part. (External data
range)</removedPart></removedParts></recoveryLog>
Data is returned, but the query is removed. Does anyone have any ideas why this might be happening?
Thanks.
John