All Code in Recently Saved Files Will No Longer Work

**masouder** · 12-17-2014, 08:20 PM

I have a problem that I cannot figure out and is making me crazy.

I have a client in another state who I send new versions of a file to every day. It is a complex file with a lot of code. All of a sudden the code in the files that I sent to him yesterday and today does not work. No code works and generates a 32809 error. ActiveX buttons do not work, but do not generate errors. (I am aware of the recent Windows update and the MSForms.exd issue.) I resent files from the last four days and those do not work either; however, a file I sent on December 9 works fine. That said, if I save the December 9 file with a new name, the code in new file does not work either. The files in question are on a flash drive that I use for portability.

I am working in Excel 2007 and all of the client's computers run Excel 2013. I have a backup laptop with Excel 2010 and all files work fine. I went to a business center today and on their computer with Excel 2010 I experienced the same issues that my client is facing. When I tested the files on my wife's computer (Excel 2007) there were no issues. When I sent a file to a friend (Excel 2010) he had the same problems.

I opened the December 9 file on my laptop and on my wife's computer, saved as a different name, sent to client and both files had problems.

So...
(1) all versions of the file work on some computers, but do not work on others. There does not appear to be any consistency across versions of Excel.
(2) as soon as I save the file that works under a different name it does not work. I tried this on three computers.
(3) other files store on the save flash drive do no seem to be affected - they continue to work in.

Like I said, I am going crazy, so any ideas are greatly appreciated.

**TMS** · 12-17-2014, 08:30 PM

You say you are aware of the .exd files issue. They need removing from all the machines where you want to run code with Active X controls.

I have 2007 on my main laptop. No problem; exd files not found. Must be 2010 and 2013 machines.

Regards, TMS

**masouder** · 12-17-2014, 08:31 PM

The thing that leads away from thinking it is related to the Windows update is that code not associated with ActiveX controls does not work either. For example I have routine that automatically unprotects a sheet when the user presses Ctrl+Shift+U. That code throws a 32809 error.

**pennom** · 01-04-2015, 03:21 PM

I have the same issue where I am getting Runtime error 32809 from files saved on one of my machines but not others. The machine causing the issue had Office 2010 but I upgraded to 2013 to try and solve the issue. It didn't solve it. I have deleted all EXD files to no avail.

The error is occuring at the following line of code

Please Login or Register  to view this content.

The PC that is causing the issue is Windows 7 now with Office 2013. I have two other PC's (Windows 7 Office 2010 and Windows 8.1 Office 2013) which can save files that run correctly but can't run code from the broken PC.

If I take a Worksheet with Macros that works on all machines and just save it on the broken machine it won't work any more on other machines but will continue to work on the machine where it was saved.

This is incredibly frustrating so any help appreciated.