#1
|
|||
|
|||
broken links in excel documents
Hello,
I have built a number of templates of excel documents that I use month to month and I keep these templates in a template folder. At the start of a new month I take a template and copy it to my current work folder and rename it for the current month. The problem that keeps arising is that important links I have inserted in the templates cease to function when I move and rename the document, even though the targets of those links have not changed. The issue for some reason is arising specifically as a result of the document being moved from the template folder and/or being renamed. Help Appreciated! Kenny |
#2
|
|||
|
|||
Quote:
Renaming the file or changing the destination file will cause issues. I know that you can changed the external data location. Have you thought about placing the templates on different worksheets and running the file that way. I know doing that can cause the program to run slow if you use formulas but that can be sped up if needed with VBA. Help Appreciated! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word-Embedded documents-links best practice | spgprivate | Word | 4 | 06-25-2013 07:47 AM |
Broken links in Microsoft Word 2007 (Help Please!) | Thomas_Anderson | Word | 0 | 09-24-2010 12:33 PM |
Updating Excel Chart Links | fermat | PowerPoint | 0 | 07-09-2010 04:29 PM |
links to excell broken after saving file | mike.taylor2@hp.com | PowerPoint | 0 | 07-01-2010 02:43 PM |
Break Links with Excel | streng | Word | 0 | 06-29-2009 02:43 AM |