Thread: Linked files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Linked files

Could be a couple of different issues.

How big is the file? How fast is your processor? How much RAM do you have?
Is the file access over a network or via your local drive? If the former,
how fast is your network connection?

Finally, perhaps Excel has to iterate through all cells linked to external
workbooks and tell itself not to update values based on those links.
--
Brevity is the soul of wit.


"Sarah at DaVita" wrote:

I have a file that has many links to other excel files. When I call up this
file I click no to update links. It still takes forever for the file to open
- just as long as if I told it to update the links. Can someone explain this
to me? Seems to me it should open quickly and just display the data that was
present the last time the file was saved.