View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Using formulas to enter NULL cell values
 
Posts: n/a
Default how do I improve performance when updating external links?

I have a 1500+ row by 36 column spreadsheet. I link in three different
spreadsheets (each representing approximately 25% of the columns). Two files
link fairly quickly (30 seconds or so). The third file takes 5-7 minutes.
How can I improve the performance of the linking process? The three external
files are all on the same network folder.