This forum will probably be shocked, but my company is just now making the switch from XP to Windows 7, and from excel 2003 to Excel 2007. The employees think we are having problems with Windows 7, but our IT group is very weak, and especially knows nothing about macros. (I am in the finance department) When I asked them to look into it, all they could tell me was the versions had been updated. In fact, the informed me they had just run 200 patches.
I did some searching on the internet & the forum to see if what issues we had were common, but most of what I found was resolved with running updates and such. But I fear there are some other "adjustments" that had to occur that aren't as well documented.
What we are seeing is this:
The issues do not happen consistently, so we cannot duplicate repeatedly. (Which in our IT world means, "I don't have a problem until you can prove there is a problem") We have 250 files that run macros, and while I have verified the calculations are occuring correctly, the function issues are very concerning. And soon people are going to start questioning if the file works correctly at all.
Has anyone else seen anything like this? Maybe it isn't about Excel or about Windows 7. But any assistance would be appreciated.
I did some searching on the internet & the forum to see if what issues we had were common, but most of what I found was resolved with running updates and such. But I fear there are some other "adjustments" that had to occur that aren't as well documented.
What we are seeing is this:
- Excel sometimes switches to R1C1 reference on its own.
- It will not stay in events enabled. I can go into VBE, and set application.enableevents=true, click back to the workbook, and go back to VBA again, and do ?application.enableevents and it comes out false. But not every time.
- When we open files, especially from a network drive, it will tell us another user has the file open (even though no one does), and we can hit "Notify" and anywhere from 10 seconds to 5 minutes later it will notify the file is available for read-write.
- I know this isn't excel - but to scope the problem - to login to the "system" (Novell for us), I know have to login once, and it will time out, and then login a second time. (We are not on ActiveDirectory)
- A file on my computer will say it does not have enable events, but is shows enabled events on another computer. But sometimes it is not on the XP computer either, but I don't know if it is because I had opened the file on my computer.
The issues do not happen consistently, so we cannot duplicate repeatedly. (Which in our IT world means, "I don't have a problem until you can prove there is a problem") We have 250 files that run macros, and while I have verified the calculations are occuring correctly, the function issues are very concerning. And soon people are going to start questioning if the file works correctly at all.
Has anyone else seen anything like this? Maybe it isn't about Excel or about Windows 7. But any assistance would be appreciated.