asked on

Excel spreadsheet locking up users computers

Hello - we have a handful of new excel spreadsheets that were created for our company by another consultant company to be used by our sales force to use for running pricing scenarios and finding sales volume figures. the spreadsheets are very large - about 10MB. When a user is local to the domain network here and they open one of these spreadsheets, they work fine. But when a user who is remote to the network opens one of these spreadsheets on their laptop, everything becomes very slow, until they close the spreadsheet. Is this an AD / VPN thing? or what?

Thanks,
Damian

SOLUTION

Alan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

John

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Damian Gardner

ASKER

I initially thought the same thing - "it must be a VPN issue". but they have copied the spreadsheet to their local desktops, rather than running it from a network resource over the VPN connection, and all the data is IN the spreadsheet (no connection required for it to work). So theoretically, the connection should not be required. Let me confirm with one of the users whether it works when they DONT connect the VPN - if its the same experience. standby

ASKER CERTIFIED SOLUTION

Alan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Damian Gardner

ASKER

sorry for the delay guys. I have to see if some of the sales guys tried the spreadsheets without the VPN. will update the case soon here. thanks guys

Alan

EE requested assistance with closing this question.