Linked Cells Not Updating

Hello - My co-workers and I have been having a lot of problems with some of our Financial Model's we've setup in Excel 2003. It use to be that if we have several workbooks open and one being the source file. If we made changes to the source file, the linked cells from the 2nd and 3rd files would automatically update. Now it doesn't automatically update anymore. To resolve this, my co-workers will have to click on the linked cell from the 2nd and 3rd workbooks and either Relink it to the source file or just hit "enter". After they've relinked the cells, it will automatically update for them in the future. However, if I were to open the same set of workbooks..source, 2nd, and 3rd files, I will experience the same problem of linked cells not updating. So if I relink the cells and save it would work for me in the future, but then the next time my coworker opens the file, they will have the problem of cells not updating. The files are located in our Work server, and we access the files from our desktops at our desk. None of us have recently modified our user settings of whether or not Excel should "prompt" us to update linked cells. We've always said no, and linked cells would refresh either on their own or when we've open the source file. Now even with source file open it won't update. It doesn't happen to every linked cell in the workbook, nor is there a specific workbook that has problems. Anyone have ANY idea of what the problem can be?

Originally Posted by quixotic1179

Hello - My co-workers and I have been having a lot of problems with some of our Financial Model's we've setup in Excel 2003. It use to be that if we have several workbooks open and one being the source file. If we made changes to the source file, the linked cells from the 2nd and 3rd files would automatically update. Now it doesn't automatically update anymore. To resolve this, my co-workers will have to click on the linked cell from the 2nd and 3rd workbooks and either Relink it to the source file or just hit "enter". After they've relinked the cells, it will automatically update for them in the future. However, if I were to open the same set of workbooks..source, 2nd, and 3rd files, I will experience the same problem of linked cells not updating. So if I relink the cells and save it would work for me in the future, but then the next time my coworker opens the file, they will have the problem of cells not updating. The files are located in our Work server, and we access the files from our desktops at our desk. None of us have recently modified our user settings of whether or not Excel should "prompt" us to update linked cells. We've always said no, and linked cells would refresh either on their own or when we've open the source file. Now even with source file open it won't update. It doesn't happen to every linked cell in the workbook, nor is there a specific workbook that has problems. Anyone have ANY idea of what the problem can be?

In Excel help, search for "Update remote link" and then see the help on "Control when links are updated"
---

I have s similar problem. I have set up references in my file, eg. ='C:\projects\CW03\resources\[CW_Resource_Integration.xls]Sheet1'!AC20

When I open the source file, the cell is updated but it does not update the format of the cells.

Can someone tell me how on the update, it'll update the destination with everything (including formats, etc.)?

Eg. source cell is blue and contains :"ABC". When the update is done, it just copies the "ABC" to the destination file and not the blue colour of the cell.

I need the blue colour and the borders, etc.

thanks.