external links

I have a number of spreadsheets which are similar and so I copied one from another. I had the same problem that many people have had about links to previous spreadsheets (the ones I copied from). I searched the internet many times and looked to solve the problem like searching for “ [ “ and...

Hello Excel fans, I have been struggling with this issue for quite a while with no luck so I decided to ask the Experts... I have made an Excel file with product list and one of the columns generates a individual hyperlink for each of the products. The issue I have is that when I click on the...

Random #REF! Error We use a large Excel file with over 1,000 external links located on one of the worksheets called the "Data Table". The external links point to other Excel files which are located on various servers. The Data Table external links work correctly most of the time. However...

Hello, I am looking for help in optimizing an Excel workbook I have. I am using Windows 7 64-bit SP1. Excel 2010. MS Access 2003. This workbook contains links through a shared drive to multiple other excel worksheets. It also contains data connections to Access 2003 select queries. I have VBA...

I created a new workbook from an existing one that adds an extra 2 sheets which both reference some of the original sheets. all of the original macros are still used for the same operation and I've added a new module with a few new macros for my two new sheets. upon opening this workbook it...

I require a formula to calculate the 5th highest value in the same cell of a large number of workbooks. Each workbook contains a large amount of data and are too big to be combined within one file. I have attempted to achieve this by using the large function with an array such as the following...

Hello All, I have an array formula that is only working when the linked spreadsheet is open. I am referencing a table, is that the problem? The formula when both sheets are open: {=IF(ROWS(B$6:B6)>$G$2,"",INDEX('[Serial Number Tracking.xlsm]Serial Credit Sheet'!A$2:A$76049,SMALL(IF('Serial...

Hi All Im uploading Excel file to our ECM system (OnBase) and get an error saying I have external links in my document. Using Edit Link I see one, it tells me the source, the type, update and Status of that link. The type is Remote file. The location the links refes to is the original...

I come here to ask for some help from my VBA expert's friends. I have about 150 .xls files where I have the measurements of the buildings where I've worked in and I need the data of these 150 workbooks in a single main file where I have monthly measurements with a general report and charts...

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...

I am using one spreadsheet (spreadsheet 1) as an order sheet. Once I have filled in all of the information, I 'Save As' with a unique title. I have another workbook (spreadsheet 2) that I use as a running log to keep track of all of the order sheets. Spreadsheet 2 has external links that...

I have a number of folders named: VO1, VO2, VO3, Each contain a workbook named; Variation 1,Variation 2, Variation 3 respectively. I need to link cells within each workbook to another workbook named: Register and need a formula I can fill down column to read a number from a cell and use as part...

I have a workbook, workbook A, with lots of cells that link to a source workbook, workbook B. I copied workbook A from my hard drive at work to do some stuff at home, but I did not copy workbook B. I can't figure out how, but when I open workbook A (at home), the links to workbook B appear to...

I am creating a template in Excel 2007 to collect data from the field for creating sales proposals. (WB1) Using another Excel 2007 Workbook (WB2), I point to a specific template ["edit link" to] "WB1" for throughput to a MS-Word Proposal. Question: How can I link to an image (specifically the...

I need to paste over cells in a range that refer to columns other than the ones they are contained in their formulas Or formulas that refer to another book using VBA. For example if the formula =A1+B1 is in column B I need to paste over that while skipping over the formula =B2+B3. Also if...

Lately, whenever I open a workbook I've been working with I get a message asking if I want to update the links to the other data sources. I do not want to simply turn off this mesage, but I would like ideas as to how to find the cell(s) that are supposedly tied to these other data sources...

Hello, I have experienced an unusual problem with formulas referring to another workbook. When re-opening the master xls file and choosing the update option, the error message "This workbook contains one or more links that cannot be updated" comes out and the formulas containing external links...

I am running Excel 2007 in Windows XP.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I would like to have an xlsx file with data and an xlsx file for the user that is linked to the data. What I need to happen for security reasons is that if...

I have a workbook with a few RTD links. Since I want to update my data manually I've set the RTD throttleInterval to -1 and force an update by running a macro with the code "Excel.Application.RTD.RefreshData". That seems to work fine. But when I close and then open my workbook the RTD data is...

I need to search for external links in a workbook using VBA. I was thinking of doing it along the lines of: If Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, _...