External Cell Links 
Author Message
 External Cell Links

I am programming a spreadsheet and cannot get excel to update the
links without prompting me to open the "source" worksheet.  I know
that there is a way to update links without opening up the source
worksheet.  Anyone know what i am doing wrong?  Thank you in advance.

Nick Florez



Fri, 25 Nov 2005 03:01:01 GMT  
 External Cell Links
Strange because when doing the update manually we don't generally see
any messages (XL97). However, Application.DisplayAlerts = False (make
sure you set back to True afterwards) should do what you want.

Regards
BrianB
==============================================

Quote:

> I am programming a spreadsheet and cannot get excel to update the
> links without prompting me to open the "source" worksheet.  I know
> that there is a way to update links without opening up the source
> worksheet.  Anyone know what i am doing wrong?  Thank you in advance.

> Nick Florez



Fri, 25 Nov 2005 11:41:28 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. External links (finding the cell(s) which contain the external reference)

2. Using cell references in external links ?

3. Identifying links to an external workbook in a cell

4. Linked cell wont update unless external file open

5. Cell link to external, variable file

6. ? Modify link beetween EXCEL cell and external data via MS QUERY

7. Link to external Word doc cell

8. Creating an external reference using a cell value as the external workbook name

9. How to dynamically update an external Excel sheet cell by cell

10. Creating a link to table in external database, then hide link


 
Powered by phpBB® Forum Software © phpBB Group