Kevin Stewart

I temporarily deleted my Personal.xlsm and that allowed spreadsheet compare to work correctly. When I have some time I'll try to work out which of my macros is causing my problems. I also discovered that the compare takes a lot longer if the sheets are in Page Layout view.

I've looked a bit further and there seems to be a problem setting the window sizes and positions. If I turn off the error handlers then I get Unable to set the Top property of the Window class. This seems to be casued by: 'Open edit form frmSyncScroll.Show vbModeless

I am running version 1.34.8 under Excel 2016 and a I have several problems: File not found message on starting Excel. This is due to the CheckForUpdates call in ThisWorkbook. Commenting out the line stops this error message. When I click on Quick Compare under Add-ins then the two files to be compared appear very small at the top of the screen and the Sync Scroll dialog appears halfway off the screen making it difficult to move back to where it can be used. Carrying out a compare is very, very slow....

I am running version 1.34.8 under Excel 2016. I too have the "File not found" problem and have tracked it down to when it checks for updates. I commented out line 73 of ThisWorkbook ('CheckForUpdates) and that stopped it. If I run Update Program.exe in Program Files (x86) then I get a connection error so I guess that there is a problem there.

Thanks for the suggestion. I thought that I would try to replicate the fault before...

Commenting out cmdAlignVertical_Click in sync seems to allow it to run. There seems...

Office 365 Excel 2013 WindowsState error - won't tile sheets

Fair enough :-) Automatic alignment of rows would be very nice. How did you plan...