Thread: How do I permanently update the file name path in the Data Link properties?
View Single Post
 
Old 05-04-2012, 08:43 AM
lynnwalder lynnwalder is offline Windows XP Office 2010 64bit
Novice
  
Join Date: May 2012
Posts: 1
lynnwalder is on a distinguished road
Default How do I permanently update the file name path in the Data Link properties?
Hopefully this will be the easiest troubleshooting thread posted on here today...

Working in Excel 2010 - Excel Database connection issue for a mail merge doc... the path to the file has changed, so every time I open up the word merge doc and it tries to connect to the excel doc via a SQL statement, I get a connection error and it opens up the Data Link box where I can manually update the path. BUT, it never saves this new path (so I have to do this EVERY time I open the word doc) - I HATE IT! How can I change the path for good so that this doesn't happen?

Thanks in advance for any help you can provide...
Reply With Quote