can not install
Performs a cell-by-cell comparison of Excel Worksheets.
Brought to you by:
stevetowner
Menu
▾
▴
#89 can not install
I downloaded v1.36.0.exe. ran it. it created the directory the help file and check for updates, but nothing to execute. i am running win10 with ms office Home and Business 2019. it created the folder in the start menu but no executable. Nothing in MS office tools. thanks and regards. Bill
There is a section in the help file that is installed in the install folder. It has workarounds for a number of issues, so try that first.
Steve
the developer option is not available. so i can not set any macro security settings.
Bill
You can try these.
Show developer tab: https://support.microsoft.com/en-us/topic/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45
Change macro settings: https://support.microsoft.com/en-us/office/change-macro-security-settings-in-excel-a97c09d2-c082-46b8-b19f-e8621e8fe373
Steve
thanks. I ended up having to copy the .xlam file to C:\Users\barvi\AppDate\Roaming\Microsoft\Excel\XLSTART the only other XLSTART was in C:\Program Files\Microsoft Office\root\Office16 and it would not let me deposit anything in that directory until after a reboot.
I now have Developer in excel. However when I launch excel it sends me 2 error messages:
After another reboot believe excel is using root\Office16. Same 2 error messages:
Sorry, Excel can't open two workbooks with the same name at the same time.
when responding to the ok checkbox, it opens the one workbook.
Any suggestions
Regards
Bill
Preference would be to go to FILE > OPTIONS > ADVANCED > GENERAL and locate the 'At startup open all file in' folder. Place the .xlam there and there only (remove all others). If you still get the error, uninstall and reinstall and UNCHECK the option to register and activate the file. You will then have to manually copy as you have done.
also when i select Add-ins and i enter a file name such as lowell_inv-new_stuff_220517b.xlsx it reports microsoft forms invalid property value.
Bill
performed reinstall as requested. can open test file new-220517a.xlsx without any errors.
selected full compare in Add-ins on this file. when i change the "Second/After file" to my 2nd file to be compared by specifying: new-220517b.xlsx it reports the error
microsoft forms
invalid property value. unable to do anything else.
regards
Bill
Try comparing two new blank workbooks and to see if it is something in the workbooks you are comparing. You can put some data in cell A1 to compare. You can also send me the workbooks as well if you want.
Steve
sorry i did not see this sooner.
i will try.
Bill
made two xlsx files. tried to compare. get same error. I include the 2 files.
tried to put 2 attachments, but only 2nd one was sent.
here is the 1st.
I am sorry for all the trouble.
After reading the help file again and looking into the compare section, I realized I needed to independently open the 2 files to compare then invoke the full compare add on. i no longer get the invalid property value error. and it appears to be comparing. it is only 11% done - update later when done.
thank you for all your help
Bill
Got it. I see the error you are seeing now. You are typing in the combobox and as soon as you click away, it generates an error because what you typed in is not an active workbook name. I don't recall why those are comboboxes instead of read only dropdown boxes, but I will look and change if I can.
Thanks, Steve
Great, thanks. I have successfully done a compare.
Database Compare
Compare Completed. Took 9793.391 Secs.
4 cell(s) out of a total of 924437 cell(s) have changed (0%).
got another error/warning while doing the above compare.
Microsoft Excel
Error 1004 (application-defined or object-defined error) in procedure
CompareWorkbooks of form frmMain
the compare tracking bar stopped around 47% - don't know if it is related.
regards
Bill
Do other workbooks compare okay? Is the issue on all worksheets within the workbook? If you getting an error during a compare, you can send me the files, or if it is private info, then narrow down where the error is by removing sheets that don't give an error, rows/columns that don't give an error until a small range that is of issue can be sent.
Steve
I have tried range compare. help file does not indicate how to fill in the fields. i do not know how to get the window that specifies to "stop on any miscompare". or how to continue / abort after finding a miscompare. when i tried the quick compare, it ran to completion but then left you with no way to find the first or any other miscompare. my file has anywhere from 28 thousand lines to 66 thousand. there should be a way to ask the tool to step to the first or Nth miscompare. I will attach a few screen shots to illustrate the processes i used. quick compare does not indicate how many miscompares there was. tell me how many pics you see. The browse mechanism only shows 1 file, I am assuming more than one file can be attached.
posting indicates it will allow you to " Add attachments" but then only allows you to add one.
here is what was to be #1
attachment 2
attachment 3
attachment 4
Three buttons on the ribbon, Full, Quick and Range. Range compares the selected ranges, meant for a quick range check, for example a simple table where you can see all the data without scrolling. This is the most basic. Quick compares the current sheet and assumes that there are not too many differences and you just want to visually see the changes. This has more features than range, but quicker than Full. Full gives the option of different output reports and stopping on error and other stuff and is the lonest to setup and run. User will often struggle if they install the program and attempt to compare massive spreadsheets right away. There are many options, so I would suggest starting with simple worksheets that are easy to see how it works.