Avatar of Craig_Kiddoo
Craig_Kiddoo
Flag for United States of America asked on

Files in Excel have "flashing" text in formula bar, won't allow changes

We have an application that seems to have caused some corruption in Excel 2007.  When I log in as the user having the problem and open an Excel file, click on a cell, I get the formula showing but it flickers and has "lines" through it.  Can't make any changes or copy and paste.

I think this came from a third party software macro, as it is happening only on the two machines that use this particular software.

When I log in to either machine under my login, Excel works fine.

I tried uninstalling and reinstalling Office, but the problem still exists.  Is there a way to do a COMPLETE AND TOTAL removal of Excel 2007?  Since it works for me, I want to "reset" the user in question and see if the problem still exists.

Thanks in advance
Microsoft Excel

Avatar of undefined
Last Comment
Craig_Kiddoo

8/22/2022 - Mon
SiddharthRout

Craig_Kiddoo:

a) What is that 3rd party software?
b) Could be because of any Add-Ins installed?
c) Can you upload a snapshot ?

Sid
Craig_Kiddoo

ASKER
SiddharthRout,

a.) The third party software is Zacks 5.0 (Investment Portfolio Management and Research Software)
b.) There are addins for the Zacks as well as another investment related program (that many others in our office use with no problems, only the Zacks users are having issues).
c.) On Monday.  I don't have the password for the user having issues.  He is on reserve duty so I can't get in touch with him until Monday.  I can't recreate the error when I log in as myself on the same machine (even tried running some reports that crashed Excel on both machines, and they work fine for me).  Both myself and the user have admin rights on the machine.
ASKER CERTIFIED SOLUTION
Zack Barresse

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
SiddharthRout

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Zack Barresse

Ha!  No.  Quite a coincidence though.  I chuckled myself when I read that.  :)

Good thinking on disabling the add-ins.  As a follow-up (Craig), make sure you check COM add-ins as well.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Craig_Kiddoo

ASKER
Thanks all...I will try tomorrow when the user is back in the office.
Craig_Kiddoo

ASKER
Didn't have any luck with the suggestions given.  It is probably due to corruption somewhere.  I fixed the problem by logging in as admin on the machine, renaming the user folder (under documents and settings, it is XP SP3).  When I logged out and had the user log back in all of the Excel issues were gone.  Of course he had to redo his personalized settings, but that was minor in comparison to the headaches Excel was causing.  Even the program that I think caused the corruption in the first place worked as intended.

Not really a fix, but a good workaround since time was of the essence.

Craig
Craig_Kiddoo

ASKER
Didn't have time to try all of the solutions proposed, they may work, may not.  My workaround solved the problem.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.