Solved

Excel Sharing Violation error

Posted on 2011-03-07
2
397 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn the basics of the new Quick Analysis feature in Excel 2013.
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.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now