I have recently bought a new machine with windows vista and I have installed office 2003. I have a number of excel sheets with links and everytime I open...

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As...

I have six spreadsheets. Each links to 6 different data spreadsheets. I just moved all of these into a couple different folders for easier maintenance. Now I...

Can I "automatically" update the link between worksheets? I moved my files to another computer and now I get message cannot find link? Thanks, JR

We are using a workbook for our payroll. The file has aheet with every employee's name plus a summary page. The file is 5.67MB. The summary page is linked...

Hi, I have the following situation: 1 Folder that contains 10 WBs + 1 WB for consolidation The folder is located under \\home share\FolderName\... Now, so...

Hi I have big problem with update links in excel file When I'm opening excel file I click button "don't update links" (I need 'old data') but I still get...

Hi, This is probably simple but is there any way to automatically update all links on opening a workbook, Without having to click a button saying...

Hi, I published this thread yesterday into the Chart forum, but I think this forum is more suitable, also because I did not get any feedback from the other...

Is it possible to update links in just one worksheet of a workbook? I have a workbook with 12 worksheets, one sheet for each month, and would like to update...

I have 3 workbooks tied together with links. One is a source only, the other two push and pull data. One of the sources, Payroll Master, on opening updates all...

Okay....I have 2 workbooks that are linked to each other, easy enough..... Lets say I have a workbook called "09-05 A" and "09-05 B" and each workbook has a...

Morning, I have a Excel spreadsheet and need to add an additional worksheet that links to an Access query. I have tried using Import Data (access database)...

I want to create external links in a bunch of excel files (50-100) to one central workbook with lookup tables. Is there any tricky way to make the sheets...

Hi all, I have an excel spreadsheet that references numerous other spreadsheets via hyperlinks. The problem is the xls was designed with the supporting...

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

I need to move Excel files to another PC. Some of the files have references to Excel workbooks. The number of linked workbooks for each file varies from 30 to...

I have 3 spreadsheets which I maintain to track sales. One for each of our branches and one which serves as a master. I've been manually typing the numbers...

Whenever a workbook is copied from one drive to another, Excel changes the links path for the various add-ins being used. Bill Manville kindly provided some...

I have a spreadsheet that is linked to 3 other spreadsheets. We keep a history of our data for each month, so the file will get renamed every month. However...