Hi,

I have a document containing many links to excel spreadsheet's graphs, numbers, texts etc. I make this document every month, everytime I copy a folder with source xls and doc files, rename it and edit spreadsheet. When I open Word doc in new folder, links are automaticly refreshed and I have this document done (all done in Office 2003).
Since I shifted to Office 2007, I'd like to do the same, but links work differently. When I copy linked docx and xlsx to another folder, links from xlsx to docx are still linked to original file in old folder (another way they are link to specific file like C:\Documents and Settings\User\Documents\May_11\Document.docx).

Can anyone please help me to solve this problem out? Is there any way to set links between xlsx and docx relatively (like link to: //source.xls)?

Thanks a lot.

tom_kladno
Czech republic (Central Europe )