One Excel file won't save to network drive

[VBAjedi]

This one's a bit baffling:

I have a user in another location who opens a complex worbook template I created, saves a blank copy, pastes in a decent chunk of data, and then is unable to save to a network drive. She IS still able to save to her local drive, and can then copy the file to the network in Explorer.

The file in question does contain extensive VBA code, but none of it should interfere with normal worksheet operations. Other Excel files are fine, it's just this file that have the problem. She emailed me the file, and I can't reproduce the behavior on my PC.

Anyone have an idea of where I can start (short of actually visiting this users location for onsite testing!)?

VBAjedi

 

[Mike555]

What is the error message she sees when attempting to save? Is the drive MAPPED for this user? If so I'd first check to make sure she doesn't have a customized local mapping assignment for that drive letter. This recently happened to me, and I spent hours trying to fix an issue before realizing that the user's P:\ was pointed somewhere different that everyone else's P:\.

--
Mike

Why make it simple and efficient when it can be complex and wonderful?

 

[VBAjedi]

The drive is mapped correctly - she can save other Excel files to the same place without difficulty. Not sure I understand what you are asking on this one - even if the shared drive IS mapped to a different letter on her PC, it should work that way from her pc, correct? I don't have any hardcoded file paths anywhere - this is just the standard File->Save operation that is failing.

The error message she gets is just "File not saved." (THANKS, M$Soft!)

VBAjedi

 

[Mike555]

I'm just making sure you're not telling the user to "Save it to the P:\ drive, and you both have different mappings to that P:\ drive. So long as her drive is mapped correctly we can rule this out. Just trying to eliminate a possible upfront issue.

--
Mike

Why make it simple and efficient when it can be complex and wonderful?

 

[VBAjedi]

Nope - it's just her local offices shared drive, and she can save other stuff there no problem.

What would make one file not save to a shared drive (but still be saveable locally, as well as transferrable to the shared drive - via Explorer - after it is saved)?

VBAjedi

 

[Mike555]

Make sure she has MODIFY access to that directory.

--
Mike

Why make it simple and efficient when it can be complex and wonderful?

 

[Mike555]

I'm sorry, I should have explained why you need to check if she has modify rights to that network drive:

Microsoft permissions get funny when a user is moving files between their local hard drive and a network drive. Windows considers a lot of things when determining if/when a user can update a file: Whether the user is cutting or copying, the format (FAT/NTFS) of both the hard drive and the network drive, and a bunch of other stuff.

Based on what you've said, I think you should check to see if the user has modify rights to that network folder. When the user copies the file to her hard drive and then to the network she is exercising her hard drive permissions which allow her to do that because she has full control of her hard drive and the file was on her hard drive before it went to the network, although she does not have Modify permissions on the network.

Sorry to be so longwinded.

HTH.

--
Mike

Why make it simple and efficient when it can be complex and wonderful?

 

[bazzert]

As far as I recall on a share its necessary for the user to have delete rights for Excel files.

The temp files needs to replace the original and this needs deleting before the temp can be saved with the same name.