disabling linked object before you open a file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a small excel file created by people in a remote location that takes
forever (more than 10 minutes) to open. the file is less than 2 mb. similarly
print previews take FOREVER
I am guessing its looking up, or trying to look up something on the far end
of our very slow VPN. how do I prevent this updating before I attempt to open
the file? while waiting for the file to open the CPU utilization maxes out
and stays there which frustrates multitasking.
thanks in advance
 
The following site has downloadable afindlinks function. You might want to
try it to see if there are links to the far end of your VPN. HTH
 
rats your link didn't post

Michael said:
The following site has downloadable afindlinks function. You might want to
try it to see if there are links to the far end of your VPN. HTH
Click to expand...
 
thanks, but its not seeing the link. there are graphs from MInitab which are
causing the problem, and the add-in didn't find the links, but we had the
author remove the graphs and the hang disappeared. thanks, but it didn't
really resolve the issue. we have to do this manually, i guess.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Links are different depending on how you open file. 3
Speed of file opening 14
Using Look in-Drop down takes long to open a folder 2
Opening Files in Excel - Runs real slow 2
Disabling Autocalculation when opening CSV files 8
Error Handling - Check a file isn't already open before overwritin 4
Slow speed opening XLSM compared to XLS 10
File takes too long to open 1

Back
Top