Solved

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

Posted on 2011-03-06
8
1,974 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
[X]
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
  • 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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 demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

617 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