Excel file crashes

I have a computer that is running windows 7 64 bit with an install of Excel 2010 32 bit.  We have about ten other machines very similar to this.  What happens is that when I open an excel file on this machine it crashes as soon as I enable macros.  However, the excel file works just fine on all of the other machines.   Initially everyone says that the excel file is corrupted but I disagree as it works fine on the other machines.  In addition if you create a brand new excel file on this machine and then do some coding in VBA and save it then the other ten machines CANNOT open it on their machines.  It seems like there is an incompatible setting on this computer with excel that causes it to crash.  I read somewhere that the date and time settings can cause this but wasn't able to apply that to this.  Any assistance would be greatly appreciated to avoid going the route of a complete reinstall of the operating system and starting over....
AccountantsTechAsked:
Who is Participating?
 
Thomas GrassiSystems AdministratorCommented:
Our computers are I7 64 bit 12 gb memory

we all use office 2010 64 bit heavy excel users no issues at all.

When would MS not recommend their product?

If you do not want to change to 64 bit thats ok

I would then try disabling all add ons
if that does not work
try uninstallling office completely
uninstall any addons
restart computer
install office
0
 
Thomas GrassiSystems AdministratorCommented:
Any errors in the application log file?

Any reason why you are not using Office 2010 64 bit version?
Office 2010 by default instsalls 32 bit they do not know how to determine what version you are running. You have to drill down to the install folder to install the 64 bit version.

I would suggest trying the 64 bit version.

REinstalling the Os is not needed.

Reinstalling Office 2010 yes

How much memory does your computers have?

How many computers do you have?

I also would suggest that you clone your computers for things like thing makes it easier to reimage a computer. Acronis is a very good cloneing product.
0
 
redmondbCommented:
Hi, AccountantsTech.

It does sound like a problem with that machine's installation. But before doing anything major, please post a copy of one of the files that it produces that can't be opened on other pc's.

Also, please give us a screen-dump of it crashing. Finally, what's the error on the other pc's?

(trgrassijr55 - the 64bit version of Excel is for very specific requirements and even MS don't recommend that it be generally used.)

Regards,
Brian.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
AccountantsTechAuthor Commented:
Error on application log file is that the faulting module name is VBE7.DLL, version: 7.0.16.27

As stated by brian 64 bit is a total disaster as it is EXTREMELY incompatible with our files.

Computer has 12GB of Memory and an Intel i7 CPU

When excel crashes it just simply says "Excel has stopped working" Doesn't give any error code etc.

In looking at the application log I am wondering if it could be running different versions of the VBE7.DLL  Anyone familiar with this or have anymore suggestions?
0
 
AccountantsTechAuthor Commented:
We are using a lot of form controls that are only compatible with 32 bit..


I did as the article said to add some code and then recompile the module.  When I do that I get the following...   Compile error:  Automation error

And then it goes to the following

Dim netIncomes() As ListRow

Any suggestions?
0
 
AccountantsTechAuthor Commented:
So what I am finding now is the code will not compile....  If you comment out the one line the it says that the next Dim is the same error..

Anyone have any suggestions?
0
 
Thomas GrassiSystems AdministratorCommented:
are you using ODBC drivers or link to other non-office applications?
How was office installed? Did you leave out any components?

I would uninstall office and any add ons

the reinstall office completely all components
0
 
AccountantsTechAuthor Commented:
Doing a complete uninstall and reinstall of office.......
0
 
AccountantsTechAuthor Commented:
Instead of doing a complete reinstall I did a repair of office and rebooted and it WORKS....
Thanks for all of your help and assistance...  It was a corrupted installation of excel....
0
 
redmondbCommented:
Thanks, AccountantsTech.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.