Solved

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

Posted on 2014-02-13
2
271 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
[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
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

729 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