Solved

Word and Excel Problem

Posted on 2014-11-16
4
159 Views
Last Modified: 2014-12-02
I have recently had Office 2013 installed, running on a Windows 7 system. I have a Word document that was created on earlier versions of Word (2010). The document is protected with a password and it contains 7 graphs which are linked to Excel spreadsheets. Once the graphs have been updated in Excel one could always update the graphs in the Word Document by selecting the “Update Link” button.  I have upgraded the Excel file containing the graphs to Office 2013 files. However trying to update the Word document to a new file with a new file name in Word 2013 seems impossible. The updated file does not save and one is returned to the dialogue box from which you saved the file. One can see the updated Word file name in the dialogue box but when, at later stage, you try and open the updated Word file, it is empty. After the first attempt to open the updated Word file, it disappears altogether.
0
Comment
Question by:stevenvanheerden
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 95

Accepted Solution

by:
John Hurst earned 500 total points
ID: 40445914
However trying to update the Word document to a new file with a new file name in Word 2013 seems impossible  

Try creating a new base Word document from the first Word document and save it without a password. That should allow Excel to function.
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 40446169
Hi stevenvanheerden  

I've had a similar issue in Wd 2010 - it refuses to save, can't even use save as... For me the problem was always related to Custom XML Parts...  

If you can reproduce the error reliably then a fix might become more likely.  I'd start with checking to see if there is any Custom XML and if so deleting it.

Another issue that I had caused document corruptions but did not prevent saving was when Word inadvertently allowed content controls to be nested in an unsupported way.  e.g. you can put a plain text content control inside a rich text content control but if you manage to do it the other way around expect trouble...
0
 
LVL 15

Expert Comment

by:DrTribos
ID: 40446176
This will list your custom xml files... you can run it on a document before and after you make changes..  I've commented out the delete line...

Sub cleanDeadXML()
' PURPOSE: Delete XML duplicates and Empty files from this
'          document.

On Error GoTo eh

Dim iXML As Integer
Dim iXML_dupe As Integer
Dim sXML As String
Dim cXML As CustomXMLParts

Debug.Print ThisDocument & " has " & ThisDocument.CustomXMLParts.Count & " XML parts"

Restart:

For iXML = ThisDocument.CustomXMLParts.Count To 1 Step -1
    If Len(ThisDocument.CustomXMLParts(iXML).NamespaceURI) < 1 Then
        Debug.Print "Delete: " & iXML
        ThisDocument.CustomXMLParts(iXML).Delete
    Else
        sXML = ThisDocument.CustomXMLParts(iXML).NamespaceURI
        Set cXML = ThisDocument.CustomXMLParts.SelectByNamespace(sXML)
        Debug.Print "Part: " & iXML & " " & sXML
        If cXML.Count > 1 Then
            For iXML_dupe = cXML.Count To 2 Step -1
                Debug.Print "Delete duplicate XML Part: " & sXML & "(" & iXML_dupe & ")"
''                cXML(iXML_dupe).Delete
            Next iXML_dupe
            Debug.Print "Restarting... "
            GoTo Restart ' Else, deleting duplicates will result in a subscript out of range error
        End If
    End If
Next iXML

lbl_Exit:
    Set cXML = Nothing
    Exit Sub

End Sub

Open in new window

0
 
LVL 95

Expert Comment

by:John Hurst
ID: 40476203
@stevenvanheerden  - Thank you and I was happy to help.
0

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Install Microsoft Office Picture Manager in Office 2013…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question