Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable Update Automatic Links
I have a user that receives orders on a spreadsheet via e-mail from a
customer on a daily basis. This user doesn't use spreadsheets with external or internal links. How can I disable Excel from attempting to update automatic links for everything that it opens? I know I can do it for a individual workbook but I want it disabled for all worksheets on this particular users computer. I appreciate any help you can give me. -- Tim Mehrley |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disable Update Automatic Links
How can I disable Excel from attempting to update automatic links for
everything that it opens? You can't. The only workaround is to open workbooks via a macro. Then you can tell Excel not to update links (the False argument): Sub a() Dim WB As Variant WB = Application.GetOpenFilename("Excel files (*.xls),*.xls") If Not WB = False Then Workbooks.Open WB, False End Sub So you'd have to provide the user with a toolbar button that ran a macro like the above (which should to be in his Personal.xls). But if he insisted in opening file by double-clicking then this wouldn't work. -- Jim "Tim" wrote in message ... |I have a user that receives orders on a spreadsheet via e-mail from a | customer on a daily basis. This user doesn't use spreadsheets with external | or internal links. How can I disable Excel from attempting to update | automatic links for everything that it opens? I know I can do it for a | individual workbook but I want it disabled for all worksheets on this | particular users computer. | | I appreciate any help you can give me. | -- | Tim Mehrley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
Update Automatic Links Not Working in 2003 | Excel Discussion (Misc queries) | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) |