I know how to update links manually yet when I go onto Edit, Links, the Manual option is greyed out - only the Automatic option is available. How can I access...

I want to be able to put a link into one workbook, that will reference/update from a chart that was created in another workbook. No problem. However, I have...

Hello, How can i trap the rename event of an excel sheet? Is it possible to get the renamed sheet name as soon as it'd changed? thanks and rgds

I'm afraid I don't know how to delete now unwanted source files from the edit/links list - I assume their presence is why I get so many windows asking if I...

I would like to be able to get data from a different workbook and have it inserted into a current worksheet. get all data under column header DATE in...

I have an extensive consolidated donor database which draws information from 5 different databases. All entries are identifiable by a number in column A. ...

After creating an Hyperlink from one page to another in a work book I get the following message :- This operation has been cancelled due to restrictions...

SGFsbG8sDQoNCkkgaGF2ZSBMaW5rIHRvIGV4dGVybmFsIHNwcmVhZHNoZWV0LCBmb3IgZXhhbXBs ZSwgZm9ybXVsYSBpbiBBMSBpcyAiPVtXZWVrMzIueGxzXVNoZWV0MSEkQSQxIi4gSXMgaXQgcG9z aWJsZS...

I am linking from an Excel 2K worksheet to a query in Access 2K. As expected, the existing cells update when the query changes. The problem is that I don't get...

I am working on a large spreadsheet and want to format files to open PDF files that correspond to the file name. Here is the format I am...

Hello, How can i trap the rename event of an excel sheet? Is it possible to get the renamed sheet name as soon as it's changed? thanks and rgds

occasionally when I entre a formula in a cell, the result is entreed in the ell as a hyperlink which seems to open an email window. I cannot seem to figure out...

thanks, but that is not the issue......no email addresses are initially entered, just a formula, say "+r5*.05".....it places the value in the dcell, but it...

Bonjour Je cherche une façon de faire pour extraire les donné (log/Lat) de mon GPS (Garmin 18 usb) . Et par la suite avec une macro les introduire a un...

We have a worksheet where entries are linked to data taken from Bloomberg, which seems to work fine. However on the second worksheet one cell is linked to this...

Hi, We are using Excel 2003, have tried both versions (pre SP1 and with SP1) We have an Excel spreadsheet that contains links to multiple files, and enter...

Hi all I'm in the process of Building a new Data Server and will be migrating data from the old server to the new server. This will result in the...

Hello We have several spreadsheets that all have multiple links to other documents on different shares. These shares will be moving to a different server in...

Greetings, a while ago MVP Bill Manville wrote a highly useful add-in called findlinks.xla which found links to external worksheets in Excel workbooks and...

Hopefully I can get the question clearly across. I have a workbook with two worksheets. One displays projects and the other displays resources. On each...