Repaired Records: External connections from /xl/connections.xml (Data connection)

%3CLINGO-SUB%20id%3D%22lingo-sub-2098606%22%20slang%3D%22en-US%22%3ERepaired%20Records%3A%20External%20connections%20from%20%2Fxl%2Fconnections.xml%20(Data%20connection)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2098606%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20removing%20an%20external%20data%20connection%20(in%20this%20case%2C%20the%20spreadsheet%20was%20connected%20to%20another%20.xlsm%20file.%20The%20reason%20is%3A%20I'm%20used%20to%20save%20new%20versions%20of%20the%20same%20file%20to%20have%20a%20manual%20backup%2C%20and%20in%20the%20last%20version%20I%20have%20copied%20some%20data%20of%20the%20previous%20version%20and%20pasted%20in%20the%20last%20version%20and%2C%20because%20of%20it%2C%20the%20Excel%20created%20a%20connection%20with%20the%20previous%20version.%20After%20that%2C%20I%20deleted%20this%20connection%20in%20data%20connections%20menu.)%20I%20saved%20a%20.xlsm%20(%3CSPAN%3Emacro-enabled%20spreadsheet).%20After%2C%20when%20I%20opened%20it%20the%20system%20ask%20to%20repair%20the%20file%20and%20then%20reports%20this%20message%3A%20%22Repaired%20Records%3A%20External%20connections%20from%20%2Fxl%2Fconnections.xml%20(Data%20connection)%22.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhat%20I%20have%20to%20do%20to%20solve%20this%2C%20because%20the%20volume%20of%20modifications%20between%20these%20versions%20is%20too%20much.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2098606%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

After removing an external data connection (in this case, the spreadsheet was connected to another .xlsm file. The reason is: I'm used to save new versions of the same file to have a manual backup, and in the last version I have copied some data of the previous version and pasted in the last version and, because of it, the Excel created a connection with the previous version. After that, I deleted this connection in data connections menu.) I saved a .xlsm (macro-enabled spreadsheet). After, when I opened it the system ask to repair the file and then reports this message: "Repaired Records: External connections from /xl/connections.xml (Data connection)".

 

What I have to do to solve this, because the volume of modifications between these versions is too much.

0 Replies