![]() |
#1
|
|||
|
|||
![]() The report template I created for our Company has about 70+ OLE links, which I think is the root cause of the issue here. The template was created in Office 2007, saved as a dotm file, and new word reports are saved as a docx files. Now, after creating and saving a new report docx file in Office 2013 from the same template, the file can take up to 5 minutes to open. However, If save the report file in the older .doc 97-2003 format, the file will open immediately with no lag. And even taking the same doc file and resaving from to docx results in the long lag in opening? All I can think is that it the OLE links are doing something. I may need to remove them all and recreate them using Office/Word 2013 and see what happens. I also noted that the initially save/conversion from a doc to docx file reduces my file size down tremendously from 1,861kb down to 402kb. |
#2
|
|||
|
|||
![]()
Well, wanted to provide an update and hoping someone may know a solution or the cause.
I have taken a Blank 2013 document and added 15 OLE Links to tables in an excel file. That word file now takes about 1 minute to open. I am also asked to save that file even though all I did was open it only, with no changes made. But if I downgrade that file as a .doc extension, the file opens almost immediately. And I am not prompted to save the file by just opening and making no changes. I can see when the file is saved as a .docx file, that Word is actually, opening and reading the excel file for each link in the background. However in the Word Advanced options, I do have "Allow automatic links at open" unchecked/disabled. And I also have all links set for a Manual update vs. automatic. An example of one of these links looks like as follows. Code:
{ LINK Excel.SheetMacroEnabled.12 "C:\\Data\\Samples\\Sample WPs.xlsm" "Cover Charts!Charts_Cover_Main" \p } I'm reading what I can but have not come across a fix yet. It appears this issue has been around since at least Office 2010. https://social.technet.microsoft.com...s-is-very-slow http://support.microsoft.com/kb/2504009 Now 4 years later, and using Office 2013, it seems this issue is still around. Last edited by ptmuldoon; 01-04-2015 at 08:14 PM. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2013 Slow in Opening File | ptmuldoon | Word | 3 | 09-16-2014 01:27 PM |
Upgrade to Office 2013? | miwin | Office | 3 | 06-19-2014 02:36 PM |
![]() |
The Chief | Excel | 1 | 01-27-2012 06:02 AM |
![]() |
chum | Word | 2 | 07-05-2010 07:06 AM |
Slow Opening Word and Excel files | itoa | Office | 1 | 05-11-2009 02:01 PM |