Jun 30 2020
07:21 AM
- last edited on
Feb 06 2023
03:05 AM
by
TechCommunityAP
Jun 30 2020
07:21 AM
- last edited on
Feb 06 2023
03:05 AM
by
TechCommunityAP
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.