Macros Excel File does not Work on All Computers

Hello, I am new to posting but have been reading these forums for a over a year now.

I have recently created a new spreadsheet for my department at my company. The sheet has around 20 macros, with none larger than ~150 lines. Last week I was presenting the spreadsheet before it became effective on an old laptop. However, the excel file would not actually run any of the macros. I investigated the laptop and versions of excel, and it was exactly the same as the computers I made the excel file on. I browsed these forums (along with others) attempting to explain the situation but only read, what I felt was, unrelated material. I ended up trying it on about 20 other computers and all worked fine, so I ended up tossing this error up to being such an old computer or something similar.

I put that spreadsheet in circulation today, which about 100 users have access on about 200 different computers. After about 3 hours, I received a complaint that the sheet wasn't working. I went over to the computer, which is one of the newer computers in the facility and found out that the same thing that occurred last week on the old computer was now showing up on this computer. So it isn't a one off. Below, I will try to explain to the best of my ability what the sheet does and what the error does. It won't make sense...

The sheet:

It is essentially a logging system that users will input their data and it gets logged into another sheet for each entry used. Then the sheet creates a pivot table from that log of entries, which only updates when you want it to (through a button macro). Other than that, I have a few acitvex comboboxes, an activex textbox. Several simple data validations and tons of formulas and index/match. Nothing special to a lot of people probably, but it was a very large project for me and learning.

The Problem:

The excel file and macros work on, so far, on all but 2 computers (tested on at least 40 computers now)

What happens:

When you open up the file. Everything is hidden but about 3 lines. Which is a dropdown to select your type of entry. Normally when you select your entry, rows will show on the data that needs to be put in. However, on the computers it don't work, nothing happens. It selection doesn't fire and it stays on those original 3 lines.

There is a button macro at the bottom of those 3 lines, labeled as Search. What it essentially does is populate the contents to make a pivot table, makes a pivot table, and hides all other sheets and you are only left on the pivot table sheet. It won't do that either, it immediately debugs. When you try to debug it, it comes up with an error on the very first line, which is essentially: (Names and password are labeled as generic for company policies)

Please Login or Register  to view this content.

The user is originally on "SheetName1". If you delete the first line and try to rerun, it will debug on the next line. I tried this for multiple lines, each line debugging.

So.... I decided to 'Record a Macro' and all I did was randomly click on a few cells and then clicked on "SheetName2". I then tried to run the macro and it was ok with selecting the random cells, but it debugged on the clicking on another sheet.

Overall. I tried playing with it a ton on those computers that wouldn't run it, and it was almost any macro that wasn't just a 'select' or 'copy' it would break. Keep in mind this is only happening on a couple computers while the vast majority it works perfectly. All the computers on the network are updated at the same time and I checked with IT to ensure those 2 computers are uptodate. I have tried restarting, having another user log in, even have the administrator login. It is something with those specific computers. I believe I checked the excel versions correctly and the service packs.

Does anybody have any ideas what this could be?

(A 3rd computer was just found while I was writing this message up)

Thank you for any help and information you are able to give.

Sorry for the late reply and thank you everybody that has shown interest in this issue. I will answer the questions that I am able to. Also an FYI that I didn't mention before. I created a sheet prior to this updated version (made from scratch though) that had macros and ran everything and all computers seem to run that. I never had a problem in the past year. Even the computers that I know can't run the new one, run the old workbook perfectly.

1.*The user didn't click on "Enable Macros" when the first opened up your sheet.
2. Some files are missing on the computers that don't run the macros.

Also - perhaps the security settings of those computers is set differently than the others?

1. I logged into the computer myself and made sure to enable macros. Even if I didn't, a popup would come up to tell me that I have disabled macros.
2. I am not sure about the some files are missing? Everything is in a single workbook, no outside references or links.

Hello Peaceofcake,

Wow!, this sounds extreme.

Please don't kill me, but have the Security and "Enable Macros" been synchronized on the other Computers defaulting?

Regards.

Last week, I looked into a lot of the macro security. Even enabled them all, and tried the 4 different settings and saved and closed and nothing ever worked. Like I said above, even if I didn't enable macros, when I tried to run a macro, it would tell me with an popup that I don't have macros enabled.

What is the error?

"Run Time Error '32809'
Application-defined or object-defined error"


I have kind of found something new. As I said before, if I get on that worksheet and try to 'record macro' and click on a different sheet and then run it, it will error with the above Run Time Error. However, if I create multiple new sheets, and record a macro switching between those 2 sheets, I do not have an error.

Thank everybody that giving me questions and suggestions.

I have found out the solution. The computers that the excel will not work on are on validated computers. These validated computers do not receive certain software updates once they are validated. Even though it appears those computers are running the current version of excel, it is missing software/service packs updates that are crucial to running the excel sheet.

This is somewhat unfortunate but not the end of the world. I am just glad that I figured out what the cause is. /resteasy

Thank you everybody for the help.