Solved

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

Posted on 2014-02-13
2
264 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:
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

Suggested Solutions

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

777 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