connections.xml issue / Office 16.38 for macOS

%3CLINGO-SUB%20id%3D%22lingo-sub-1498717%22%20slang%3D%22en-US%22%3Econnections.xml%20issue%20%2F%20Office%2016.38%20for%20macOS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498717%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20desperate%20here...%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3EI'm%20using%20Excel%20on%20my%20mac%20a%20lot%2C%20with%20external%20connections.%3C%2FP%3E%3CP%3EI%20update%20them%20using%20a%20macro%20script.%3C%2FP%3E%3CP%3EOnce%20in%20a%20while%2C%20that%20script%20would%20break%20my%20file%2C%20and%20I%20would%20get%20an%20error%20message%20that%20the%20file%20needs%20to%20be%20repaired.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20this%20is%20not%20every%20time%2C%20as%20soon%20as%20I%20create%20a%20new%20external%20connection%20to%20a%20text%20file%2C%20even%20in%20a%20new%20blank%20excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20what%20I%20have%20tried%20so%20far%20%3A%3C%2FP%3E%3CP%3E-%20Completely%20uninstall%20excel%20and%20delete%20all%20the%20system%20files%3C%2FP%3E%3CP%3E-%20Reinstall%20the%20latest%20up%20to%20date%20version%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20create%20a%20new%20spreadsheet%2C%20add%20an%20external%20connection%20to%20a%20simple%20.csv%20file%2C%20save%20the%20spreadsheet%20and%20close%20it.%20When%20I%20reopen%20my%20excel%20file%2C%20I%20get%20an%20error%20message%20that%20the%20file%20needs%20to%20be%20repaired.%3C%2FP%3E%3CP%3EIf%20I%20hit%20%22yes%22%20on%20it%2C%20it%20opens%20the%20file%20and%20tells%20me%20it%20repaired%20%22%2Fxl%2Fconnections.xml%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%0A%3CRECOVERYLOG%20xmlns%3D%22http%3A%2F%2Fschemas.openxmlformats.org%2Fspreadsheetml%2F2006%2Fmain%22%3E%3CLOGFILENAME%3ER%C3%A9parer%20le%20r%C3%A9sultat%20vers%20test2.xml%3C%2FLOGFILENAME%3E%3CSUMMARY%3EDes%20erreurs%20ont%20%C3%A9t%C3%A9%20d%C3%A9tect%C3%A9es%20dans%20le%20fichier%20%C2%AB%26nbsp%3B%2FUsers%2Fflorian%2FDesktop%2Ftest.xlsx%26nbsp%3B%C2%BB%3C%2FSUMMARY%3E%3CREPAIREDRECORDS%20summary%3D%22Liste%20des%20r%C3%A9parations%26nbsp%3B%3A%22%3E%3CREPAIREDRECORD%3EEnregistrements%20r%C3%A9par%C3%A9s%3A%20R%C3%A9f%C3%A9rence%20de%20formule%20externe%20dans%20la%20partie%20%2Fxl%2Fconnections.xml%20(Connexion%20de%20donn%C3%A9es)%3C%2FREPAIREDRECORD%3E%3C%2FREPAIREDRECORDS%3E%3C%2FRECOVERYLOG%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20looked%20into%26nbsp%3Bconnections.xml%2C%20and%20it%20contains%20nothing%20out%20of%20the%20ordinary%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%0A%3CCONNECTIONS%20xmlns%3D%22http%3A%2F%2Fschemas.openxmlformats.org%2Fspreadsheetml%2F2006%2Fmain%22%20mc%3D%22http%3A%2F%2Fschemas.openxmlformats.org%2Fmarkup-compatibility%2F2006%22%20ignorable%3D%22xr16%22%20xr16%3D%22http%3A%2F%2Fschemas.microsoft.com%2Foffice%2Fspreadsheetml%2F2017%2Frevision16%22%3E%3CCONNECTION%20id%3D%221%22%20uid%3D%22%7B4DA4CBD9-B6C1-4441-BB12-F04004FD9E25%7D%22%20name%3D%22statpup3%22%20type%3D%226%22%20refreshedversion%3D%226%22%20background%3D%221%22%20savedata%3D%221%22%3E%3CTEXTPR%20sourcefile%3D%22%2FUsers%2Fflorian%2FDesktop%2Fstatpup3.csv%22%20decimal%3D%22%2C%22%20thousands%3D%22%E2%80%AF%22%20tab%3D%220%22%20semicolon%3D%221%22%3E%3CTEXTFIELDS%20count%3D%229%22%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3CTEXTFIELD%3E%3C%2FTEXTFIELD%3E%3C%2FTEXTFIELDS%3E%3C%2FTEXTPR%3E%3C%2FCONNECTION%3E%3C%2FCONNECTIONS%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20honestly%20tried%20everything.%20If%20someone%20has%20a%20clue%20on%20what%20I%20could%20check%2C%20I%20would%20really%20appreciate%20it%2C%20as%20excel%20is%20%22unusable%22%20for%20me%20right%20now.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1498717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%202019%20for%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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