Hello, I am having a problem with a link in one of my Excel worksheets and I'm hoping that someone can help me with it. Here's the situation... I have two...

I have an excel work book downloaded daily. The workbook contains pricing. On occasion the pricing will move from cell to cell. Is there a way to define the...

I have several workbooks which are source links to a master sheet. I rename these workbooks each week after I am finished with the week's data. (I...

I'm using Excel 2003 I have a workbook open and am using 2 worksheets. On sheet 1 I get information from the internet and then transfer three cells of it to...

Excel 2003 I want to allow users to choose a month via a validation box and see data relevant to that month. Other worksheets/workbooks contain the data to...

If I have in a cell reference =SUM(A3:A300) how to have 3 and 300 referenced to another cell so that I can change range without changing formula?

I have Windows XP and Excel 2002 SP3, I have go into EditLinksStartup Prompt and selected the radio button for Don't display the alert and update links. ...

Hi, I've got a workbook with various links into it (as shown via Edit, Links...). However, I cannot find the cells that are linked. Can anyone show me an easy...

Hello Is there a function NameOfFunctionAnalogOfLookup(lookup_valueInFirstColumn,lookup_valueInFirstRo w,table_array) or an analog...

Dear all, I have a formula which works fine, but when I copy it to the next cell the formula appears as text rather than actually doing anything. For...

I'm using Excel to index several thousand gif files. When I create a hyperlink to a gif file on my C drive, the link works as expected until I save the...

I have a sheet that will list certain results from many other sheets, I would like the link to be dynamic so when I change the value in one cell it calls a...

Can a VBA routine be written to change external links to manual updating after they have been initially created in a workbook and that workbook has been...

Hi, I'm working with Excel 2003. I have a workbook (created with Excel 97) which contains hyperlink to external files (Word, and PDF files). When I click to...

Is there anyway to change the drive letter existing links are using automatically, instead of opening each file and clicking on Edit-Links-Change...

I have spent more hours than I care to admit trying to figure out the code for copying rows that have updated date to a master sheet. I have a command button...

Hello everyone, I need a method to extract the list of documents an excel document is linked to *without* opening the file (or, if it definitely has to...

Hello How to 'Trace dependents' for all cells in a selection at once?

I have a cell that references a named cell on another worksheet within the same workbook. I save and retrieve the first worksheet for storage. Upon retrieval...

The standard "Import External Data" function in Excel makes it easy enough to obtain a single record in Excel from an Access database, but I'm trying to figure...