If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inconsistent Links on shared network drive
This problem is very frustrating because the links don't
work at 2:30 but work at 2:35 with no action taken other than closing and re-opening the file. We have a master file, where our central office puts questions into column A. The remaining columns are for responses from each division office. The questions in the master are linked to a file for each division where they show up in column A. The answers from the divisions are entered into the division files, which link back to the master. Sometimes everybody can see the questions/answers, sometimes not. When the linked info isn't visible, there is no error message. Only one or 2 people may have a problem at any given time, and the rest of the group will be fine. Then, it just seems to fix itself. We have problems with the master and division files. All files are on the same network drive, just in different folders. Most (if not all) users are on Office/Windows 2003. Any ideas on how to keep these problems from occuring is appreciated. Thank you! Erin |
#2
|
|||
|
|||
Inconsistent Links on shared network drive
Erin wrote:
Sometimes everybody can see the questions/answers, sometimes not. When the linked info isn't visible, there is no error message. Is it just that you are not seeing changes that have been made to other files since you opened the file you are looking at? That would be normal behaviour. To see the changes the changes would need to have been saved and then you would need to update the links (Edit / Links / Update Now) Otherwise: - what answer did you give to the "update links" dialog on opening the workbook - what is your calculation mode (Tools / Options / Calculation) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom toolbars and shared drive | Andrew | General Discussion | 4 | June 25th, 2004 11:15 PM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Links to Add-in on network | Shaun Farrugia | Links and Linking | 0 | February 3rd, 2004 06:44 PM |
Excel Links to files on network not updating | Bobbie Jo | Worksheet Functions | 0 | January 13th, 2004 10:02 PM |
Excel links on network: sharing file off network | Vicki | Worksheet Functions | 1 | December 5th, 2003 10:47 PM |