Compare checking for Update

2026-03-18T12:59:26.263000Z

Steve, Thanks --- Really appreciate you quick reply!

I had wondered about that; even checked to see if "Never" was an option.

Just curious, any idea why when I run the update exe, I get "Unable to determine if an update is available?"

Compare checking for Update

2026-03-18T03:42:23.204000Z

If you run the Update Program.exe in the install folder (i.e. C:\Program Files (x86)\Spreadsheet Compare), then click on the Options tab, you can set check interval in days. If you put 1000 days, then that should hold it off for a while.

Compare checking for Update

2026-03-17T20:58:44.960000Z

Occasionally, I'll get a dialog box indicating (I think) the add-on is trying to check for a new version, an failing.

Doesn't seem to happen on my desktop (Windows 10) but more when I'm traveling and using laptop connected wifi......the box keeps opening each time I open Excel (v2016).

Is there a setting/option somewhere that controls this behavior that I can turn off?

Also, how do I determine what version on Spreadsheet Compare that I currently have installed?

Thanks - I have been using this add-on for years and it has never failed!

Variable not defined

2026-01-21T16:49:22.870000Z

Steve, Thanks for your support. It's working again.
Scott

Variable not defined

2026-01-21T15:29:59.363000Z

Try v.1.41.0 I uploaded last week. I think that fixed the issue.

Variable not defined

2026-01-21T15:13:30.223000Z

Steve, have you had a chance to work on this?

Thanks,

Scott

Variable not defined

2026-01-10T21:13:35.898000Z

Steve,

Thanks for digging into this for me.

I tried your suggestion to delete the lines with ref. It allowed me to get further, but when I clicked on "compare", I received an error.

I look forward to hearing back from you.

Variable not defined

2026-01-09T21:42:35.180000Z

I have found a colleague who has the same computer I have that has the same issue as you. It seems to be a permissions issue with Excel and the refEdit control that ships with Excel. I was unable to immediately fix his issue, but at least I have a computer with the issue that I work on to resolve this. So give me some time to troubleshoot the issue with him and I will post a solution.

One thing you can do is delete the lines with ref... that come up in error as that control is missing. The refedits are not required for all the compare features, so you may find you can still do what you need to do with them removed.

Variable not defined

2026-01-09T15:44:15.542000Z

Steve, thanks for the continued help.

I confirmed that RefEdit Control is checked and is at the same location on my PC that it is on yours.

What do you mean by "try the installation troubleshooting section for the same file."? Are you referring to the installation troubleshooting for spreadsheet compare or something else?

Here is some additional background that may help. For the past 10 years, I've used Spreadsheet Compare on a daily basis for a small business that I run. I've been lucky that it has just worked without issue until recently. I have created a couple of Excel Macros so I know a little about macros, but I'm really just a novice.

This issue appeared a few days ago on the PC that I've been using for the past year. I tried my wife's PC. It worked correctly once on her PC, but then I had the same error on her PC. I thought the error might somehow be caused by the spreadsheets, but my business partner is still able to use Spreadsheet Compare for the spreadsheets.

As part of troubleshooting, I have uninstalled and reinstalled both Spreadsheet Compare and Office 365. I have also followed the instructions for "Checking/Correcting References" and "Checking/Adding Required Controls" in the help documentation for Spreadsheet Compare Installation and Troubleshooting.

I appreciate any other suggestions.

Variable not defined

2026-01-09T02:07:52.720000Z

In 'Checking/Correcting References', check that RefEdit Control is checked. If not, browser for it and enable it. For me it is in c:\program files\microsoft office\root\office16\refedit.dll. You can also try the installation troubleshooting section for the same file.

Recent posts to Discussion

Compare checking for Update

Compare checking for Update

Compare checking for Update

Variable not defined

Variable not defined

Variable not defined

Variable not defined

Variable not defined

Variable not defined

Variable not defined