A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Inconsistent Links on shared network drive



 
 
Thread Tools Display Modes
  #1  
Old July 30th, 2004, 07:37 PM
Erin
external usenet poster
 
Posts: n/a
Default 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  
Old July 30th, 2004, 11:53 PM
Bill Manville
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 05:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.