VBA, Prompts to update links when opening Excel spreadsheet from Access

Prompts to update links when opening Excel spreadsheet from Access

Author	Message
helluvagoodtim #1 / 3	Prompts to update links when opening Excel spreadsheet from Access Hello All, Need some help. When I open an Excel spreadsheet from Access via some codes, a prompt always appear, asking if I want to have my links in the spreadsheet updated. I simply do not want this prompt to appear, and the links are there for legitimate reasons. How can I do this? Regards
Fri, 24 Oct 2003 04:03:45 GMT

Slavk #2 / 3	Prompts to update links when opening Excel spreadsheet from Access Hi! Try in Excel Tools\|Options\|Edit and empty checkbox "Ask to update automatic link". This should solve the problem. Regards, Slavko Quote: > Hello All, > Need some help. > When I open an Excel spreadsheet from Access via some codes, a prompt always > appear, asking if I want to have my links in the spreadsheet updated. I > simply do not want this prompt to appear, and the links are there for > legitimate reasons. How can I do this? > Regards
Sat, 25 Oct 2003 00:39:17 GMT

helluvagoodtim #3 / 3	Prompts to update links when opening Excel spreadsheet from Access Thank You.
Sat, 25 Oct 2003 08:43:58 GMT

Page 1 of 1

[ 3 post ]