Not all users allowed to save shared workbook

S

Stedman

New Member
Joined
Aug 26, 2009
Messages
46
I have created and shared a workbook on my network at work. While some people have no issue making changes and saving, other cannot save and get this error when attempting to, referencing an (as far as I know) non-existent file.

mlh5ci.jpg


The one variable I have discovered is that when I open the Share Workbook window the names of the people who cannot save show twice, where people who are not having the issue only show up once. These people do not have more than one instance of the workbook opened and everyone is running on Office 2007.

Does anyone have any experience with an issue like this?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Stedman said:
Does anyone have any experience with an issue like this?
Click to expand...

Yes, Shared Workbooks suck and should be avoided at all costs.

One thing that can happen over a network is that shared wb's can create ghost copies that need to be deleted. I haven't used them for years, but if I recall you also need to go in and delete the ghost users.

HTH,
 
Upvote 0
Yeah, I've tried saving it as .xlsx and .xls (it was originally .xlsm) to see if that would solve the issue, but these users keep having it come up as 'Read-Only.'

Even though everyone is on Office 2007, I'm thinking it must be some sort of compatibility issue where those with the problem are missing some sort of Windows Update or something.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Can you co-author an excel file without using SharePoint or OneDrive? Possible other options available?
Replies
0
Views
1K
PA_VA13
P
SandsB
  • Question
Co-authored or shared with M365 or One Drive?
Replies
0
Views
270
SandsB
SandsB
BrettOlbrys1
  • Question
Cached version of Excel showing up for some users?
Replies
0
Views
268
BrettOlbrys1
BrettOlbrys1
Chris_010101
  • Question
VBA Update Links
Replies
3
Views
627
Josu
J
V
  • Solved
Share a formula with table references.
Replies
3
Views
223
vanwooten
V

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top