Currently facing an incomprehensible issue with Excel...
We have developed a work order electronic package that is used by about one hundred users every day. It is essentially the exact same workbook that is copied and transferred to users (for them to fill). The file is full of macros that do a variety of things...
We received new computers recently (Windows 8, 64 bit, Office 2013) and everything was working fine everywhere, at first.
Suddenly, about two weeks ago, we started getting issues that defy logic on some computers only.
On certain computers only, the workbooks simply do not work. We get unexpected runtime errors "32809" for no reason when running macros or other runtime errors for no reason... Some basic code just fails to function on certain computers only. In other words I could take the exact same file and run it on two identical computers and the same macro would throw an error on one and work perfectly on the other. I can also take a perfectly working file on one computer send it to a user, if that user simply hits "CTRL + S" then sends the file back to me, the file's macro wouldn't work anymore. This does not make sense, at all.
In the "corrupt" file, I even tried writing some new code for testing... The most basic code like Sheets("Job Time Sheet").Select won't even work. Two sheets can't be access programmatically, for some reason (again, on certain computers only).
The origin of the error seems to be two specific sheets (even though again, the workbook works fine on several computers). If I create copies, then delete them, the file starts working again. But because those two sheets can't be accessed with VBA, the repair process can't be automated and needs to be done manually, which is not acceptable.
The whole thing does not make sense. I thought that Windows/Office Updates were to blame for this and made sure that the computers we were using for testing all had the most recent updates. Didn't change a thing.
On some of the computers that were corrupting the files, we also tried uninstalling/re-installing office, with no success.
Anybody has an idea of what might be the problem????? Again, the fact that the same identical files works on 70% of the computers only defies logic. We all have the exact same computers, settings etc.
Note we did not have this problem when we were using our older computers and Windows 7/Office 2013. This all started with the new machines.