|
| 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
June 15th, 2004, 02:56 PM
|
|||
|
|||
Same workbook links will not update automatically
Is there a reason why links within the same workbook will not update
automatically especially when excel is set to update links automatically? A linked cell will update once double clicked!!! Thank you in advance. 
|
|
#2
June 16th, 2004, 01:23 AM
|
|||
|
|||
|
Same workbook links will not update automatically
Henry wrote:
Is there a reason why links within the same workbook will not update automatically especially when excel is set to update links automatically? A linked cell will update once double clicked!!! Thank you in advance. Are you using Excel 2002 or later? What are the Edit / Links / Startup settings? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
|
#3
June 16th, 2004, 01:05 PM
|
|||
|
|||
|
Same workbook links will not update automatically
I am using Excel 2002 SP2. The Edit/Links menu is grayed out.
"Bill Manville" wrote in message ... Henry wrote: Is there a reason why links within the same workbook will not update automatically especially when excel is set to update links automatically? A linked cell will update once double clicked!!! Thank you in advance. Are you using Excel 2002 or later? What are the Edit / Links / Startup settings? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
|
#4
June 16th, 2004, 11:15 PM
|
|||
|
|||
|
Same workbook links will not update automatically
Sorry - I missed the implication of "same workbook links"
Try Tools / Options / Calculation / Automatic Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
|
#5
June 17th, 2004, 01:17 PM
|
|||
|
|||
|
Same workbook links will not update automatically
Thank you for the response. Those options were checked as you indicated. But
the problem persists. I found no help from MS knowledge base. "Bill Manville" wrote in message ... Sorry - I missed the implication of "same workbook links" Try Tools / Options / Calculation / Automatic Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
|
#6
June 17th, 2004, 07:05 PM
|
|||
|
|||
|
Same workbook links will not update automatically
Henry wrote:
Thank you for the response. Those options were checked as you indicated. But the problem persists. I found no help from MS knowledge base. Does Ctrl+Alt+F9 have any effect? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
|
#7
June 18th, 2004, 08:20 PM
|
|||
|
|||
|
Same workbook links will not update automatically
Ctrl+Alt+F9 did update the links, but that's not a good solution. Thanks
for your help. "Bill Manville" wrote in message ... Henry wrote: Thank you for the response. Those options were checked as you indicated. But the problem persists. I found no help from MS knowledge base. Does Ctrl+Alt+F9 have any effect? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
|
#8
June 19th, 2004, 01:46 AM
|
|||
|
|||
|
Same workbook links will not update automatically
Henry wrote:
Ctrl+Alt+F9 did update the links, but that's not a good solution. Thanks for your help. That suggests there may be a problem with the workbook's calculation chain. If you are using Excel 2002 or later, with the workbook active, Alt+F11 to the VB editor, Ctrl+G to the immediate window and Application.CalculateFullRebuild In earlier versions try Edit / Replace / = / = / Replace All Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
