auto update links

M

Mohamed

i have a link to a cell in another workbook every time i open this workbook
it tells me that if I need to update links so howcanI make it update by
default and without asking me
 
G

Gord Dibben

Tools>Options>Edit. Uncheck "Ask to update automatic links".


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto update 3
Saving through a network affecting ability to update automatically 1
Breaking links between workbooks in Excel 2000 1
Update links (repost) 2
how to find and unlink current worksheet from old worksheet 3
Update links 1
How to create absolue path link to another workbook (Excel 2003) 1
Updating Links from Closed Source Workbooks 2

Top