VPN User cannot save Excel occasionally

We have a VPN user that is having issues when trying to save files. It does not always happen.

When she opens a file (Ex: XLS) through the VPN, it seems that people that are on site can still open and edit the file.
Then she finish and tries to save, but is unable to because someone else has it open onsite.

Is there a solution that will lock the file so that other can't edit it while she is?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MouseCaptainHelp Desk AnalystCommented:
Is the file on a mapped network drive?  If so, my guess is the local Internet or wi-fi when working remotely is intermittent, and it loses the lock when the connection is lost.  You can test this by confirming no one is able to open the file immediatley after she opens it (which would likely be before the connection is lost).

If the file is stored in a SharePoint library--if available--she can "check out" (i.e. "lock") a file before working on it so no one else can edit it until she checks it back in.

Alternatively, a Citrix portal provides a more consistent connection to network files than does a VPN, as Citrix apps are typically run inside the network and are made available to remote users as their Internet remains connected.  If their remote connection fails, the files remain open and connected on the server, waiting for them until their connection is restored.

hope this helps
Steven CarnahanNetwork ManagerCommented:
An alternative to Citrix is RDS.  All our work is done through RDS so it is all done on the server. This is also a good security measure for remote users that have laptops. Since nothing is stored on the laptop then private information won't be compromised if the laptop is lost/stolen.
jjwolvenAuthor Commented:
The files she opens are not open very long - reportedly a few minutes.
She opens it, changes it, save and closes it.

Our initial (and current) suspect is wifi dropping as you said.

I will look into RDP as an option, but are there any other possibilities you can think of?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jjwolvenAuthor Commented:
It looks like we will be pushing for terminal services as a solution for this.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.