Apr 04 2019 02:37 PM
If this is not the right location to ask this question, please refer me to the correct one.
Using Excel 2016 (Office 365)
Microsoft Excel for Office 365 MSO (16.0.10730.20304) 64-bit
We are trying to troubleshoot why an excel spreadsheet with formulas is taking a long time to calculate (15 minutes). There is another computer we tested on and it calculates in about 45 Seconds.
Two difference I noticed on the computer that runs the calculations faster, are:
Security settings for Linked Data Types
and
Security settings for Dynamic Data Exchange.
I am including a screenshot.
On my computer, I do not have those 2 additional options.
I have already enabled DDE using the registry:
Windows Registry Editor Version 5.00
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options]
"DontUpdateLinks"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options]
"DontUpdateLinks"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Options]
"DontUpdateLinks"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options\WordMail]
"DontUpdateLinks"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Word\Options\WordMail]
"DontUpdateLinks"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Options\WordMail]
"DontUpdateLinks"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\OneNote\Options]
"DisableEmbeddedFiles"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\OneNote\Options]
"DisableEmbeddedFiles"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options]
"DontUpdateLinks"=dword:00000000
"DDEAllowed"=dword:00000000
"DDECleaned"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options]
"DontUpdateLinks"=dword:00000000
"DDEAllowed"=dword:00000000
"DDECleaned"=dword:00000000
"Options"=dword:00000117
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options]
"DontUpdateLinks"=dword:00000000
"DDEAllowed"=dword:00000000
"DDECleaned"=dword:00000000
"Options"=dword:00000117
Any suggestions would be helpful.
Please let me know what additional information you need.
Dec 27 2019 01:50 PM
Where?????? Show me where Data Types is in Office Excel 2016???? I've been looking for hours.... Your message refers to it.... Where is it???
Aug 25 2021 10:16 AM
@4ullpl8t11955 I have the same problem.. anyone...?
Jun 01 2022 10:46 PM