Solved

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

Posted on 2011-03-06
8
1,882 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

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…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

770 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