• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Excel spreadsheet shows open cells as locked on one computer only

Excel spreadsheet shows open cells as locked on one computer only. Worksheet is distributed by a company portal to multiple users at home.  Spreadsheet works well save for one user only. When this workbook with three spreadsheets is opened with Office or OpenOffice Calc,  many cells on different sheets show as locked when values are input and the cell is moved away from.

This is the only computer on which this issue exists. The Spreadsheet opens, populates well and calulates, and saves normally on 75 other stations in different places (not on same network).  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
SteveDico
Asked:
SteveDico
  • 2
1 Solution
 
luconstaCommented:
That excel file have some VBA code?... if the problem is related only to a single PC but different similar applications (Office and OpenOffice) maybe there is some code that specifically lock that cell on a specific PC.
0
 
SteveDicoAuthor Commented:
This pc is possible to be locked ....but I found that if I use hotkeys to toggle between sheets the systems locks cells...so I use mouse only.


THanks for the help anyway!
0
 
SteveDicoAuthor Commented:
This was a good suggestion but did not apply in this case
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now