(Msg. 9) Posted: Tue Nov 11, 2008 9:41 am
Post subject: Re: Links not updating automatically [Login to view extended thread Info.] Archived from groups: microsoft>public>excel>links (more info?)
"Bill Manville" wrote:
> Links will almost always work if the source workbook is open (unless
> the destination workbook has a broken calculation tree - hence the
> Ctrl+Alt+F9 suggestion).
>
> There are a number of possible reasons for problems with links when the
> source workbook is closed, but we have already eliminated some of
> those. I will look at the workbooks when I get them.
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup
>
>
(Msg. 10) Posted: Tue Nov 11, 2008 9:45 am
Post subject: Re: Links not updating automatically [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I've just come searching for an answer to exactly the same problem. I've got
a workbook with links to another workbook that do update, and to another that
don't (unless I've opened it first; doesn't matter if it's subsequently
closed again). I'll be well pleased if someone can answer it.
(Msg. 11) Posted: Tue Jan 13, 2009 6:11 pm
Post subject: RE: Links not updating automatically [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi
I have exactly the same problem, I have links to an external workbook and
they are not updating. I have checked all the settings to enable external
links update with no luck but I noticed if I have the book that the links are
pointing to open the links works. I beleive this is started when we installed
the new Excel 2007.
I hope someone can find an answer tho this issue.
regards
Ed
"Alright_Flower" wrote:
> Hi. I have a 7-workbook Excel spreadsheet, which contains links to several
> other spreadsheets.
>
> When I open the document, I click Yes to the "Do you want to update links?"
> question, but the information in the linked cells is not updated. However,
> if I click on the cell, then click at the end of the link in the formula bar
> and press Return, the link updates.
>
> I've checked that the "update remote references" checkbox is marked on the
> Calculation tab in Tools...Options and now I'm stuck. Any help much
> appreciated. Thanks.
>
> Lisa
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2
Page 2 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office