Solved

Excel Sharing Violation error

Posted on 2011-03-07
2
399 Views
Last Modified: 2012-05-11
When I try to save an Excel template sheet to a job number, the message I get is:

‘your changes could not be saved to ‘7000.xls’ because of a sharing violation. Try saving to a different file.’

I press ‘OK’ and it has changed the file name to something random with letters and numbers and then it lets me save it under that name.

If I try and change the file name back to 7000 it then says ‘cannot save Y:/Work Order Estimates 7000.xls. The folder is marked as read only’.

This is only random spreadsheets, some are ok in the same location.
0
Comment
Question by:NWCCSteve
2 Comments
 
LVL 5

Accepted Solution

by:
kpltechgroup earned 500 total points
ID: 35065824
Someone else has them open?

Also check if its on a network share, and make sure you have full read AND write permissions to the file.

Also try disabling macros to see if the problem goes away. I remember once we had a excel file that opened up a copy in the background and sometimes didn't close properly (so the hidden copy) wouldn't let you save because 2 were open at the same time.

Let me know!

Mike
0
 

Author Closing Comment

by:NWCCSteve
ID: 35355504
The customer has fixed there problem, but I havent soken to them about how it was resolved, Thanks again
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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
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 …
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

831 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