Solved

open cells act as locked on one computer only for an Excel spreadsheet

Posted on 2014-02-13
2
261 Views
Last Modified: 2014-04-08
Excel spreadsheet shows open cells as locked on one computer only.

Worksheet is distributed by a company portal to multiple users at home by email .  Spreadsheet works well for all users but one... . When this workbook with three spreadsheets is opened with Office or OpenOffice Calc and values are input into certain cells, many cells on different sheets show as locked .

This Spreadsheet opens, populates well and calulates, and saves normally on 75 other stations in different places (not on same network).  This is the only computer on which this issue exists. There are certain cells that are locked. These  are titles, ext.

Where should I begin my troubleshooting efforts on this machine? I have not reinstalled Office, because issue is identical with another application, as indicated.

Thanks for the assist.

Steve
0
Comment
Question by:SteveDico
2 Comments
 
LVL 24

Accepted Solution

by:
lionelmm earned 500 total points
ID: 39858884
First thing I would so is take the file and save it on the local PC--then check to see if that file has full control permissions for that user on that PC for that file that is now on that PC. Open it and see if the problem persists. Second, if the issue is still there with the local file as well, I would run Office repair rather than a reinstall.
0
 

Author Comment

by:SteveDico
ID: 39860791
I will try this !  Thank you!
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

758 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

20 Experts available now in Live!

Get 1:1 Help Now