Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-02-13
2
Medium Priority
?
275 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 1500 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

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…
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

719 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