Seems like the only way to get the most current information from
linked cells in a sheet opened in read-only mode is to answer yes when
prompted about updates when opening the sheet.
If the source sheet is then revised, must I close and re-open the

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

Does anyone know what determines whether a file is opened
with a UNC path or a mapped drive path?  
The problem we are having is related to a linked file.  It
was created and saved with the links to a source file

Hi
I created some worksheets in 2000 and 2002xp.  I move
between the two no problem.  I recorded a couple of simple
macros which work fine.  I drew some rectangles in 2000

I would like to convert a range of figures to a set
currency , say Barbados $ to £Sterling , based on the
current daily Exchange Rate , and update or refresh from
the web site whenever I connect to the internet.

A number of people are having issues with opening a powerpoint
presentation with linked excel graphs in it.  At present there a 5
graphs that are linked.  They were link by copying the excel graph and
pasting them into powerpoint as a link.  The first time you open the

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 automatically
update links yes/no...?

I have a number of interlinked spreadsheets, when I try to edit a
linked sheet using Edit-Links and click on the Change Source button, I
can select the new spreadsheet that I wish to link to, however once I
click OK, Excel hangs for quite some time, and in some cases (10

Hi!
Sorry if this is been seen twice by some people - I did
not see this option for links!!
I have been given a database of names, addresses and

I have created a web query in Excel to download "key statistics"for a stock
into my spreadsheet.
The url  and query is  http://finance.yahoo.com/q/ks?s=PFE
Selection=yfncsumtab,21,24,26,29,32,35,38,41,44

I am having trouble resizing a linked excel worksheet so
that the whole worksheet displays in a word document but
not as an icon.
Please help it' sdriving me mad.

I have read the article that excel can auto insert the file name in a cell
using this:
=LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".",
MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3)

I have a workbook with multiple sheets containing
repeated references to different external documents.
Currently I have it set up so that I have an "Index" work
sheet which contains a list of the required documents and

Hi wonder if you could help me... I have a file that when
I open it, it says not enough memory... This is due to a
link within the file somewhere...?
The problem is Ive searched every sheet (only 5) and I

Can anyone explain why what I see happening, described below, is occurring.
I have a weekly report submitted to me by Email. The structure of each these
weekly submission is identical as it made from a template file. The users
insert links into the template which brings in figures. ...