Solved

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

Posted on 2011-03-06
8
1,844 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 30

Assisted Solution

by:SiddharthRout
SiddharthRout earned 250 total points
Comment Utility
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 14

Expert Comment

by:Zack Barresse
Comment Utility
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
Comment Utility
Thanks all...I will try tomorrow when the user is back in the office.
0
 

Author Comment

by:Craig_Kiddoo
Comment Utility
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
Comment Utility
Didn't have time to try all of the solutions proposed, they may work, may not.  My workaround solved the problem.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now