Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2011-03-06
8
1,906 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Craig_Kiddoo
  • 4
  • 2
  • 2
8 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35046939
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
0
 

Author Comment

by:Craig_Kiddoo
ID: 35046955
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.
0
 
LVL 14

Accepted Solution

by:
Zack Barresse earned 250 total points
ID: 35047255
For removing Office, look here:

http://officearticles.com/misc/remove_microsoft_office_from_your_pc.htm

It could be something else causing this, but in an overall view, it may just be faster to remove and reinstall.  If removing registry items make a backup of your registry first, then make your changes.  Your Office version is 12 (the above linked tutorial went to 2003).  This could also be something in other macro enabled files as well, i.e. Personal.xlsb, etc.  You could check those if you wanted to as well.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 30

Assisted Solution

by:SiddharthRout
SiddharthRout earned 250 total points
ID: 35047273
Zack(firefytr): Does that 3rd party software (Zacks 5.0) has to do anything with you ;)

Craig_Kiddoo: Also before you do a a re-install, disable all Add-Ins and then check if MS office hangs. If it doesn't then one by one enable the Add-Ins. This will narrow it down to the culprit Add-In.

Sid
0
 
LVL 14

Expert Comment

by:Zack Barresse
ID: 35047282
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.
0
 

Author Comment

by:Craig_Kiddoo
ID: 35048339
Thanks all...I will try tomorrow when the user is back in the office.
0
 

Author Comment

by:Craig_Kiddoo
ID: 35074189
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
0
 

Author Closing Comment

by:Craig_Kiddoo
ID: 35074211
Didn't have time to try all of the solutions proposed, they may work, may not.  My workaround solved the problem.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question