edit links

Hi I've got a workbook with a dashboard in it and it contains links to other workbooks. I changed settings so that the links are updated automatically and the dashboard is continually up to date. For some reason now, the links not only don't update automatically but when i click on Edit Links...

Situation: I have a number of .xls files that function as "source" files, meaning that I use them to store various kinds of data. The data are used by many different "report" files (also .xls) by means of links between workbooks. For example, I have several different kinds of "sales report"...

Hi everybody! I've got this problem (excel 2010): when I open a file, I've got the error message that I've a broken link: it cannot update the data from a certain file. It tells me from which file it cannot download the data (also seen in "Edit Links") but it does not say which is the cell that...

Hi, The EDIT LINKS screen isnt long enough to see the directory of the link to make sure its right. Can anyone suggest an update or change or anything to make this screen adjustable? Cheers

Hi, Iv'e searched the forum but unfortunatly can't find the answer, hoping someone can help. If in the current workbook I have a link to another workbook how can I have a marco to bring up the Edit>Links dialog box and then selects change source? To make life easier say I have the link is...

Hello, I created an add-in (.xlam) in Excel 2007 which has a number of user-defined functions. The add-in was deployed to a shared network folder as read-only so: (a) it could be referenced by multiple users at the same time and (b) we could easily deploy changes. The individual functions...

Here's a challenge to the Excel Guru's out there. I have a workbook that is linked to many other books. Each week the path of the link changes to a different folder. I've parsed the path into several cells and only need to change a single cell with the new date and all of the parsed cells...

In the Edit Link message box (Edit / Edit Links), there are a number of columns of information about files that have been linked too. In most cases the file would be a "Worksheet" but I have some appearing as "Remote File". What does this mean and is there a way to control the type of file it...

Hello, I have been frustrated by this problem for some time- Whenever I try to update the source for data links in 2007 (Data>Connections>Edit Links>Change Source) excel ALWAYS freezes! I've tried this on other machines as well and the same thing happens... useful info: -I am trying to change...

I'm using Excel 2007. I have 2 files: http://rstr.us/e/stm-m.xlsm and http://rstr.us/e/stm-b.xlsm The first contains links to the second, but using a different name. When I open the first and go to SourceAttributes sheet, I see in D22 a real link and the cell shows the linked cell's value...