LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Corey
 
Posts: n/a
Default External Link - Conditional

I have a workbook that has external links. Except that it's a
sumif(external,internal,external) type formula. I have no problem clicking
'Update Links' in other workbooks and it will give me live information, yet
in this particular one, I have to manually go open the workbook for it to
update. Is there a limitation to the auto update due to it being in a formula
instead of just grabbing an exact value from an external? It's referencing 12
workbooks and it can be quite time consuming to open and close them all.
Thanks!
 
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
FInding external link Fred Smith Excel Discussion (Misc queries) 1 August 31st 05 02:54 AM
How do I use a cell value as the filename in an external link? wattkisson Excel Discussion (Misc queries) 5 July 11th 05 09:07 PM
How do I use a cell value as the filename in an external link? wattkisson Excel Worksheet Functions 1 July 8th 05 11:51 PM
External link using calculated cell value Doug Excel Worksheet Functions 1 March 15th 05 08:05 AM
Save External Link Values Stephane Excel Discussion (Misc queries) 0 January 3rd 05 11:01 AM


All times are GMT +1. The time now is 03: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"