locked
Spreadsheet Compare missing from Office 365 ProPlus RRS feed

Answers

  • I have fixed the problem in two ways:
    1) Enabling the button in Excel following this HowTo:

    Turn on the Inquire add-in

    2) Repairing the installation with an "online repair".

    After this, I can find a folder in the Start menu called "Microsoft Office Tools" with the "Spreadsheet Compare" tool.

    Thanks to all of you.

    • Marked as answer by thenewmessiah Monday, October 28, 2019 1:37 PM
    Monday, October 28, 2019 1:37 PM

All replies

  • Spreadsheet Compare is a separate application, it is not part of Excel itself.

    Click the Start button in Windows and start typing spreadsheet compare - after a few characters you should see Spreadsheet Compare in the search results.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, October 25, 2019 2:35 PM
  • Hi thenewmessiah,

    Make sure that you're looking for it at the right place:

    • In Windows 7: On the Windows Start menu, under Office 2013 Tools, click Spreadsheet Compare.
    • In Windows 8 (also Windows 10): On the Start screen, click Spreadsheet Compare. If you do not see a Spreadsheet Compare tile, begin typing the words Spreadsheet Compare, and then select its tile.


    https://support.office.com/en-us/article/basic-tasks-in-spreadsheet-compare-f2b20af8-a6d3-4780-8011-f15b3229f5d8

    Friday, October 25, 2019 2:38 PM
  • I can't find it in the Start menu on Windows 10 Pro
    Friday, October 25, 2019 2:50 PM
  • Hi thenewmessiah,

    Make sure that you're looking for it at the right place:

    • In Windows 7: On the Windows Start menu, under Office 2013 Tools, click Spreadsheet Compare.
    • In Windows 8 (also Windows 10): On the Start screen, click Spreadsheet Compare. If you do not see a Spreadsheet Compare tile, begin typing the words Spreadsheet Compare, and then select its tile.


    https://support.office.com/en-us/article/basic-tasks-in-spreadsheet-compare-f2b20af8-a6d3-4780-8011-f15b3229f5d8

    Nothing to do, it's missing from the Start Menu.
    Friday, October 25, 2019 2:52 PM
  • Manually check for "SPREADSHEETCOMPARE.exe" in the following paths depending on your configuration:

    • C:\Program Files\Microsoft Office 15\root\office15\DCF
    • C:\Program Files (x86)\Microsoft Office 15\root\office15\DCF
    • C:\Program Files\Microsoft Office 16\root\office16\DCF
    • C:\Program Files (x86)\Microsoft Office 16\root\office16\DCF


    If it's not there either, please share a screenshot of the version of your Office installation from "File > Account" screen of any Office app.


    • Edited by Burak VAROL Friday, October 25, 2019 3:40 PM
    Friday, October 25, 2019 3:40 PM
  • Hi,

    Please follow these steps:

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Monday, October 28, 2019 8:14 AM
  • Hi,

    Please follow these steps:

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    It's missing from the Start Menu.
    Monday, October 28, 2019 10:19 AM
  • Manually check for "SPREADSHEETCOMPARE.exe" in the following paths depending on your configuration:

    • C:\Program Files\Microsoft Office 15\root\office15\DCF
    • C:\Program Files (x86)\Microsoft Office 15\root\office15\DCF
    • C:\Program Files\Microsoft Office 16\root\office16\DCF
    • C:\Program Files (x86)\Microsoft Office 16\root\office16\DCF


    If it's not there either, please share a screenshot of the version of your Office installation from "File > Account" screen of any Office app.


    Following your tips, I have searched for SPREADSHEETCOMPARE.EXE under "C:\Program Files\Microsoft Office\" and I found it under "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Office\Office16\DCF".

    But it doesn't works; I can open it, but when I click on the button to select the first file, it crash with this error:

    crash

    This is the full log:

    See the end of this message for details on invoking 
    just-in-time (JIT) debugging instead of this dialog box.
    
    ************** Exception Text **************
    System.InvalidOperationException: Operation is not valid due to the current state of the object.
       at DCF.Common.MSOInterop.MsoMethods.InitializeMsoIfNecessary(IntPtr hwnd)
       at DCF.Common.MSOInterop.MsoMethods.OfficeFileOpen(String fileTypes, StringBuilder buffer, Int32 size)
       at ProdianceExcelCompare.CompareFiles.ShowOfficeFileDialog()
       at ProdianceExcelCompare.CompareFiles.btnBrowse1_Click(Object sender, EventArgs e)
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    
    
    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.4042.0 built by: NET48REL1LAST_C
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    SpreadsheetCompare
        Assembly Version: 16.0.0.0
        Win32 Version: 16.0.11901.20170
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/SPREADSHEETCOMPARE.EXE
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.4042.0 built by: NET48REL1LAST_C
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.4001.0 built by: NET48REL1LAST_C
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.3752.0 built by: NET48REL1
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    Common.AuditItems
        Assembly Version: 16.0.0.0
        Win32 Version: 16.0.11901.20170
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Common.AuditItems.DLL
    ----------------------------------------
    Infragistics2.Win.UltraWinChart.v11.1
        Assembly Version: 11.1.20111.1003
        Win32 Version: 11.1.20111.1003
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Infragistics2.Win.UltraWinChart.v11.1.DLL
    ----------------------------------------
    System.Data
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.3752.0 built by: NET48REL1
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Core
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.4042.0 built by: NET48REL1LAST_C
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.3752.0 built by: NET48REL1
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Data.DataSetExtensions
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.3752.0 built by: NET48REL1
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.DataSetExtensions/v4.0_4.0.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
    ----------------------------------------
    System.Configuration
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.3752.0 built by: NET48REL1
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    Infragistics2.Win.v11.1
        Assembly Version: 11.1.20111.1003
        Win32 Version: 11.1.20111.1003
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Infragistics2.Win.v11.1.DLL
    ----------------------------------------
    Infragistics2.Shared.v11.1
        Assembly Version: 11.1.20111.1003
        Win32 Version: 11.1.20111.1003
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Infragistics2.Shared.v11.1.DLL
    ----------------------------------------
    Infragistics2.Win.UltraWinToolbars.v11.1
        Assembly Version: 11.1.20111.1003
        Win32 Version: 11.1.20111.1003
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Infragistics2.Win.UltraWinToolbars.v11.1.DLL
    ----------------------------------------
    Syncfusion.Shared.Base
        Assembly Version: 9.203.0.138
        Win32 Version: 9.203.0.138
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Syncfusion.Shared.Base.DLL
    ----------------------------------------
    System.Numerics
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.3752.0 built by: NET48REL1
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
    ----------------------------------------
    Accessibility
        Assembly Version: 4.0.0.0
        Win32 Version: 4.8.3752.0 built by: NET48REL1
        CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
    ----------------------------------------
    Common.MsoInterop
        Assembly Version: 16.0.0.0
        Win32 Version: 16.0.11901.20170
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Common.MsoInterop.DLL
    ----------------------------------------
    Common.ExcelServices
        Assembly Version: 16.0.0.0
        Win32 Version: 16.0.11901.20170
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Common.ExcelServices.DLL
    ----------------------------------------
    Common.ClientConfiguration
        Assembly Version: 16.0.0.0
        Win32 Version: 16.0.11901.20170
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Common.ClientConfiguration.DLL
    ----------------------------------------
    Infragistics2.Win.Misc.v11.1
        Assembly Version: 11.1.20111.1003
        Win32 Version: 11.1.20111.1003
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Infragistics2.Win.Misc.v11.1.DLL
    ----------------------------------------
    Syncfusion.Grid.Windows
        Assembly Version: 9.203.0.138
        Win32 Version: 9.203.0.138
        CodeBase: file:///C:/Program%20Files/Microsoft%20Office/root/VFS/ProgramFilesX86/Microsoft%20Office/Office16/DCF/Syncfusion.Grid.Windows.DLL
    ----------------------------------------
    
    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.
    
    For example:
    
    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>
    
    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.
    
    
    

    My Office version is Office 365 (16.0.11901.20170) 64 bit

    Thanks

    Monday, October 28, 2019 10:31 AM
  • I have fixed the problem in two ways:
    1) Enabling the button in Excel following this HowTo:

    Turn on the Inquire add-in

    2) Repairing the installation with an "online repair".

    After this, I can find a folder in the Start menu called "Microsoft Office Tools" with the "Spreadsheet Compare" tool.

    Thanks to all of you.

    • Marked as answer by thenewmessiah Monday, October 28, 2019 1:37 PM
    Monday, October 28, 2019 1:37 PM
  • Did you find solution on this? I am having same error, long one.
    Saturday, January 11, 2020 8:21 AM
  • I try to start the option from the Start menu and nothing happens.  Thanks!

    Here's version info...


    Friday, February 21, 2020 8:11 PM
  • To: anon
    re:  comparing worksheets

    You might want to try the free 'Professional_Compare' workbook.
    A cell by cell comparison Or an each row to all rows comparison (between two worksheets).
    Download from MediaFire (no ads)... http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents





    Saturday, February 22, 2020 5:26 PM