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

Excel Sharing Violation error

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
NWCCSteve
Asked:
NWCCSteve
1 Solution
 
kpltechgroupCommented:
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
 
NWCCSteveAuthor Commented:
The customer has fixed there problem, but I havent soken to them about how it was resolved, Thanks again
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.

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