ShufflePoint users can create reports that strain Excel to the breaking point. This is often manifest in Excel crashing when you try to save a file. This is due to the creation of erroneous data connections "hidden" in the document. Luckily there's a quick solution.

1. Open the file that will not save.

2. Click on the "Developer" tab in the Excel ribbon menu (read this to enable the developer tab if it is not already visible).

3. Click on the Visual Basic editor and then right click on the VBA project with the same name as your workbook and choose Insert > Module.

4. Paste the following code into the new window and close the editor.

     Option Explicit
          Sub DeleteUnboundConnections()
          Dim conn As WorkbookConnection
          For Each conn In ActiveWorkbook.Connections
               If conn.Ranges.Count = 0 Then
                    conn.Delete
               End If
          Next conn
     End Sub

5. Run the macro - it will appear as though nothing has happened.

6. Save the workbook (you can save as xslx since the macro isn't needed)

The result is a new workbook which has been "cleansed" of its errant connections.

 - Chris Harrington