I've tried deleting links via the Links Dialogue and the Defined Names windows and I 've tried using code to delete the names. But my code returns an error...

Excel 2003 SP2 The problem relates to a workbook not being able to access data in a linked workbook that resides in a different sub-directory. I have five...

Hi, I have a excel which stores URL and its short description. I need to have a cell in other excel to have the "short description" from first excel and when...

I now use Excel 2003. BAck in Excel 2000 there was an add-in "Access Links" which allowed conversion of Excel Listfile data to an Access table. I cant find...

I am having a problem linking one workbook to another. Let me lay it out... I ahve a database that runs a query and then uses a macro to "Output to" the query...

Win XP; Office 2003 Paste formula from linked files. This is the command I'm using: on the destination file; highlighted the cell with the formula -- ...

I use many external database queries in my worksheets. To refresh results, I simply right click in the data and select Refresh. Sometimes, however, after the...

I am working on 2 Excel files with multiple tabs and spreadsheets going out to Col. EU. I don't have any problem when I am working on these files at my home...

I created an excell file, and I am refreshing the excell queries using ActiveWorkbook.RefreshAll function, but everytime I need to enter the username and...

I have the following Macro (which I need to run on approximately 200 different workbooks) -- what is the BEST way to achieve this? Should I use a Function...

test

Hello, I am attempting to run an Excel macro that creates thousands of hyperlinks to other sheets within the same file. On one of my larger sheets the macro...

I am trying to look up a reference value in a excel worksheet cell in an access database to display, in excel, a value related to that reference. i.e. enter a...

Hello folks. I need to link or embed the value of a single cell in excel into an html email in an outlook public folder. The value of the cell contents will...

Hello, I have a simple workbook that consists of two worksheets, first with data and second with maps relating to that data. I have links throughout the first...

Does anyone know how I can resolve this issue ... I have a directory which contains 129 worksheets which have links to external data (in a Master Spreadsheet)...

I suspect that (since I didn't get any response on my previous request for assistance) I may need to approach this in stages ... Assuming that Information...

I suspect that (since I didn't get any response on my previous request for assistance) I may need to approach this in stages ... Assuming that Information...

Does anyone know the best approach for this? I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional spreadsheets which have ODBC links to various...

Hi All, I have an Excel (Excel 2000 SP3) file (2 Mbytes) with about one thousand hyperlinks to word document or excel document. This Excel file is situated on...