Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by active8it
at 2024-08-02 05:37:16
ModifyPoint:500 Replies:4 POST_ID:828666USER_ID:11550
Topic:
Microsoft Excel Spreadsheet Software;;Microsoft Office Suite
We have a user who is finding pre-existing Excel spreadsheets very slow to open when using the companies wifi connection; this is the case no matter where he opens them from - including his local C: drive
If we open up Excel on its own (i.e. a completely new workbook) it opens in seconds. Any pre-existing document takes a minute or more however.
On a LAN connection he seems fine.
The company does segregate the LAN and wifi networks - meaning company shared drives are not available on the wifi connection. I believe the issue may relate back to the share drives.
I have changed 'Show this number of Recent Documents' to zero (in case it was looking for a recent document on an inaccessible share) and disabled all non essential add ins but the problem remains.
However if I remove the 'unavailable' shared drives from Computer then Excel opens correctly/quickly.
To clarify - if he logs in on the wifi, network shares are automatically created in Computer but are 'disconnected' (red cross over the drive). If I 'Disconnect' the shares completely (Right Click > Disconnect) then everything works ok. If I leave them, existing spreadsheets are very slow to open, even from C:
When using the LAN connection the shared drives are accessible anyway, so the issue is not present.
I have tried creating test documents which literally only contain one cell of data saying 'Test' - I have saved these in both .xlsx and .xls format to see if that was an issue but the same problem is present. Document size is also 'irrelevant' as the same issue occurs even on very small spreadsheets (10KB for example)
I'm assuming Excel is trying to find some sort of file or similar on the shares before timing out and opening the program. But I am not sure what file this might be (as recent documents are effectively off)
He is using Office 2010 Pro Plus. All other modules open 'fine' (i.e. quickly)
If we open up Excel on its own (i.e. a completely new workbook) it opens in seconds. Any pre-existing document takes a minute or more however.
On a LAN connection he seems fine.
The company does segregate the LAN and wifi networks - meaning company shared drives are not available on the wifi connection. I believe the issue may relate back to the share drives.
I have changed 'Show this number of Recent Documents' to zero (in case it was looking for a recent document on an inaccessible share) and disabled all non essential add ins but the problem remains.
However if I remove the 'unavailable' shared drives from Computer then Excel opens correctly/quickly.
To clarify - if he logs in on the wifi, network shares are automatically created in Computer but are 'disconnected' (red cross over the drive). If I 'Disconnect' the shares completely (Right Click > Disconnect) then everything works ok. If I leave them, existing spreadsheets are very slow to open, even from C:
When using the LAN connection the shared drives are accessible anyway, so the issue is not present.
I have tried creating test documents which literally only contain one cell of data saying 'Test' - I have saved these in both .xlsx and .xls format to see if that was an issue but the same problem is present. Document size is also 'irrelevant' as the same issue occurs even on very small spreadsheets (10KB for example)
I'm assuming Excel is trying to find some sort of file or similar on the shares before timing out and opening the program. But I am not sure what file this might be (as recent documents are effectively off)
He is using Office 2010 Pro Plus. All other modules open 'fine' (i.e. quickly)
Accepted Solution
Expert: John Hurst replied at 2024-08-02 07:14:01
500 points GOOD
The wifi is purposely kept separate from the LAN,
This is probably why Excel cannot check for updating workbooks. Have you checked for that?
Also, make sure drives are NOT persistent. Better the user logs on, maps folders, and then disconnects all drives when switching to WiFi.
Turn off persistence, build two batch files: one to connect, one to disconnect. Show the user and have them disconnect when going to WiFi.
... Thinkpads_User
This is probably why Excel cannot check for updating workbooks. Have you checked for that?
Also, make sure drives are NOT persistent. Better the user logs on, maps folders, and then disconnects all drives when switching to WiFi.
Turn off persistence, build two batch files: one to connect, one to disconnect. Show the user and have them disconnect when going to WiFi.
... Thinkpads_User
Author: active8it replied at 2024-08-02 06:48:55
Hi Duncan - I will check the routing next time the user laptop is available to me
Thinkpad - wifi speeds are 'ok'; not lightning fast but not terrible either. Unfortunately due to the nature of his role he often moves around the site so needs to use the wifi frequently
The wifi is purposely kept separate from the LAN, so changing that set up is not really an option - this is also part of why he keeps some documents saved to C: so he doesn't require access to the shared folders all the time (meaning we'd have to alter the wifi/LAN settings, which they don't want to do)
Thinkpad - wifi speeds are 'ok'; not lightning fast but not terrible either. Unfortunately due to the nature of his role he often moves around the site so needs to use the wifi frequently
The wifi is purposely kept separate from the LAN, so changing that set up is not really an option - this is also part of why he keeps some documents saved to C: so he doesn't require access to the shared folders all the time (meaning we'd have to alter the wifi/LAN settings, which they don't want to do)
Expert: John Hurst replied at 2024-08-02 06:05:02
Perhaps the worksheet has a link to a server file that is not available when on WiFi. That will certainly cause the issue you have.
If the WiFi link is slow (not uncommon in some circumstances) perhaps the user is simply better to use a LAN connection. Either that, or make the links available locally.
.... Thinkpads_User
If the WiFi link is slow (not uncommon in some circumstances) perhaps the user is simply better to use a LAN connection. Either that, or make the links available locally.
.... Thinkpads_User
Expert: duncanb7 replied at 2024-08-02 06:01:36
Could you do the following command on
the computer that want to open xls file ?
net USE X: \remotecomputernameexcelfolder
and
open the excel file at x: directory to see what is speed different first ?
it might be routing issue
the computer that want to open xls file ?
net USE X: \remotecomputernameexcelfolder
and
open the excel file at x: directory to see what is speed different first ?
it might be routing issue
