connections.xml issue / Office 16.38 for macOS

Occasional Visitor

Hello Everyone !

 

I am desperate here... :)

I'm using Excel on my mac a lot, with external connections.

I update them using a macro script.

Once in a while, that script would break my file, and I would get an error message that the file needs to be repaired.

 

But this is not every time, as soon as I create a new external connection to a text file, even in a new blank excel spreadsheet.

 

Here is what I have tried so far :

- Completely uninstall excel and delete all the system files

- Reinstall the latest up to date version

 

If I create a new spreadsheet, add an external connection to a simple .csv file, save the spreadsheet and close it. When I reopen my excel file, I get an error message that the file needs to be repaired.

If I hit "yes" on it, it opens the file and tells me it repaired "/xl/connections.xml".

 

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>Réparer le résultat vers test2.xml</logFileName><summary>Des erreurs ont été détectées dans le fichier « /Users/florian/Desktop/test.xlsx »</summary><repairedRecords summary="Liste des réparations :"><repairedRecord>Enregistrements réparés: Référence de formule externe dans la partie /xl/connections.xml (Connexion de données)</repairedRecord></repairedRecords></recoveryLog>

 

 

 

I looked into connections.xml, and it contains nothing out of the ordinary :

 

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<connections xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="xr16" xmlns:xr16="http://schemas.microsoft.com/office/spreadsheetml/2017/revision16"><connection id="1" xr16:uid="{4DA4CBD9-B6C1-4441-BB12-F04004FD9E25}" name="statpup3" type="6" refreshedVersion="6" background="1" saveData="1"><textPr sourceFile="/Users/florian/Desktop/statpup3.csv" decimal="," thousands=" " tab="0" semicolon="1"><textFields count="9"><textField/><textField/><textField/><textField/><textField/><textField/><textField/><textField/><textField/></textFields></textPr></connection></connections>

 

 

 

I honestly tried everything. If someone has a clue on what I could check, I would really appreciate it, as excel is "unusable" for me right now.

0 Replies