Solved

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

Posted on 2014-02-13
2
267 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 25

Accepted Solution

by:
Lionel MM 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

809 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