Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I avoid annoying Update Links message
I find more and more that I get the "update links?" question when I open a
workbook. I make frequent use of sheet names in formulas. Does the message appear if I simply use a sheet name in a formula in the workbook? I wish I could at least figure out what "link" Excel thinks it sees, and tell it to forget it. Can I? This is minor, but annoying to me. For someone not familiar with Excel's eccentric ways, the message can cause panic. |
#2
|
|||
|
|||
Can I avoid annoying Update Links message
Hi, Joe. Try this:
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "phillyjoe" wrote in message ... I find more and more that I get the "update links?" question when I open a workbook. I make frequent use of sheet names in formulas. Does the message appear if I simply use a sheet name in a formula in the workbook? I wish I could at least figure out what "link" Excel thinks it sees, and tell it to forget it. Can I? This is minor, but annoying to me. For someone not familiar with Excel's eccentric ways, the message can cause panic. |
#3
|
|||
|
|||
Can I avoid annoying Update Links message
?B?cGhpbGx5am9l?= wrote
I find more and more that I get the "update links?" question when I open a workbook. I make frequent use of sheet names in formulas. Does the message appear if I simply use a sheet name in a formula in the workbook? I wish I could at least figure out what "link" Excel thinks it sees, and tell it to forget it. Can I? This is minor, but annoying to me. For someone not familiar with Excel's eccentric ways, the message can cause panic. The way I read your msg, you don't want to be asked, but want to keep any links Excel interprets as such. You don't say what version of Excel you are using, but here in XL2000, there's an option to suppress or allow: Tools|Options|Edit tab Ask to update automatic links -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update a closed file via links | Excel Discussion (Misc queries) | |||
Auto Update Links | Excel Worksheet Functions | |||
broken links message still popping up | Excel Discussion (Misc queries) | |||
How can avoid the security Macro message ... | Excel Discussion (Misc queries) | |||
Update Links - Problem | Links and Linking in Excel |