Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default External Links Taking too long

I have a spreadsheet that I have three Vlookups into external spreadsheets.
Two of them work brilliantly, but one takes ages to complete, unless the
file is open.
I have checked and I can't see any reasons why this should be. I have used
findlink.xla and made sure that the links are correct and there are no
duplications.
There are also a number of macro's run that are also very slow unless the
problem spreadsheet is open

If anyone can help or give advise it would be greatly appriciated
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default External Links Taking too long

Such can be the nature of the beast.
I'm guessing that the two which work quickly are quite small files.
I can think of very little that can be done to improve this. One option
would be to create your self a macro to open the offending file take a copy
of the data into a spare tab and refer to that. The down side is that you
have to remember to 'update'.

I've been at the point where you are and sometimes you just have to have
your reference files open.

Giz



"Sean" wrote:

I have a spreadsheet that I have three Vlookups into external spreadsheets.
Two of them work brilliantly, but one takes ages to complete, unless the
file is open.
I have checked and I can't see any reasons why this should be. I have used
findlink.xla and made sure that the links are correct and there are no
duplications.
There are also a number of macro's run that are also very slow unless the
problem spreadsheet is open

If anyone can help or give advise it would be greatly appriciated

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating external links Al Links and Linking in Excel 1 May 30th 06 07:41 AM
Preserve existing data whilw using external links Hal Excel Worksheet Functions 0 April 7th 06 01:38 AM
#REF on Links to Named Range in External Workbook [email protected] Excel Discussion (Misc queries) 1 April 6th 06 03:02 PM
External links Andrew Clark Excel Discussion (Misc queries) 1 June 28th 05 04:26 AM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"