Asked by active8it
at 2024-08-02 05:37:16
Point: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)
