Linked Workbooks

N

Nick

I have a workbook, file A, saved on a shared server and I
am the only one with write access.
Another department has another read only file, B on their
shared server.
We have linked cells between files. When either file is
opened, the person is asked to open it as read only, this
in OK but they are also asked if they want to up-date the
link.
Question (1). Is there any way of making the link up-date
happen without prompting the user?
Question (2). The linked cells in both files are formatted
as text.
If I up-date file A and some of those linked cells in file
A are blank, the linked cells in file B display a zero
value.
How can file B, be formatted so there is no zero values?

I hope this makes sense.
Nick
 
F

Frank Kabel

Hi
for the first question:
Goto 'Tools - Options - Edit' and uncheck 'Ask to update automatic
links'

Second question:
change your formula to something like
=IF('[book1.xls]sheet1'!A1="","",'[book1.xls]sheet1'!A1)
instead of a simple link
 
Top