Is that what you mean by wired, being on desktop?
No, with 'wired' I mean accessing the file on the remote server by way of wired ethernet only, and NOT via a wireless link. There are 3 conditions you'd like to get data on: (1) copying the file to your local machine, and accessing the file on the remote server, either by (2) an exclusively wired network connection, or (3) a connection involving one or more wireless links.
- If the wired connection doesn't show the problem, that excludes Excel's handling of the remote file as the culprit, because it shouldn't matter if the hookup is wired or wireless. Instead it would point to the wireless link (as the remaining variable) as the most likely source of the problem. However, in that case simply copying the file should be slow as well, which is not what you say you see.
- If the wired hookup also shows the problem,
that would include Excel's file handling as a possible source.
Still, you need to get the info on all 3 conditions to be sure. After all, we may be missing yet another possibility, and you want to base your troubleshooting on real observations, not on conjecture.
