ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Problem with links form a word file to excel graphs (https://www.excelbanter.com/links-linking-excel/234261-problem-links-form-word-file-excel-graphs.html)

SavvasC

Problem with links form a word file to excel graphs
 
I have a word document in 2003 format that had hyperlinks with graphs created
in an excel 2003 file. The links were updated automatically every time the
data (graphs) were refreshed in the excel.
After upgrading to office 2007 the hyperlinks from the excel to the word
document do not update.

macropod[_2_]

Problem with links form a word file to excel graphs
 
Hi SavvasC,

If you've updated the file formats for the Excel files from the '.xls' format to '.xlsx', the links in the Word file will still be
looking for the old 'xls' versions. You'll need to edit the links to fis that. Plus, if you've changed to Vista, the filepaths are
likely to be different and you need to edit those too.

--
Cheers
macropod
[Microsoft MVP - Word]


"SavvasC" wrote in message ...
I have a word document in 2003 format that had hyperlinks with graphs created
in an excel 2003 file. The links were updated automatically every time the
data (graphs) were refreshed in the excel.
After upgrading to office 2007 the hyperlinks from the excel to the word
document do not update.



sc

Problem with links form a word file to excel graphs
 
Dear macropod,

thank you for your immediate response and answer on this issue. I tried copy
paste-special link from the .xlsx version and it doesnt work. Also, keep in
mind that we didn't upgrade form XP to Vista. We are still using XP Pro.

"macropod" wrote:

Hi SavvasC,

If you've updated the file formats for the Excel files from the '.xls' format to '.xlsx', the links in the Word file will still be
looking for the old 'xls' versions. You'll need to edit the links to fis that. Plus, if you've changed to Vista, the filepaths are
likely to be different and you need to edit those too.

--
Cheers
macropod
[Microsoft MVP - Word]


"SavvasC" wrote in message ...
I have a word document in 2003 format that had hyperlinks with graphs created
in an excel 2003 file. The links were updated automatically every time the
data (graphs) were refreshed in the excel.
After upgrading to office 2007 the hyperlinks from the excel to the word
document do not update.




macropod[_2_]

Problem with links form a word file to excel graphs
 
Hi sc,

Have you checked whether Word 2007 is configured to automatically update the links (Word Options|Advanced General Update
automatic links at open)?

--
Cheers
macropod
[Microsoft MVP - Word]


"sc" wrote in message ...
Dear macropod,

thank you for your immediate response and answer on this issue. I tried copy
paste-special link from the .xlsx version and it doesnt work. Also, keep in
mind that we didn't upgrade form XP to Vista. We are still using XP Pro.

"macropod" wrote:

Hi SavvasC,

If you've updated the file formats for the Excel files from the '.xls' format to '.xlsx', the links in the Word file will still
be
looking for the old 'xls' versions. You'll need to edit the links to fis that. Plus, if you've changed to Vista, the filepaths
are
likely to be different and you need to edit those too.

--
Cheers
macropod
[Microsoft MVP - Word]


"SavvasC" wrote in message ...
I have a word document in 2003 format that had hyperlinks with graphs created
in an excel 2003 file. The links were updated automatically every time the
data (graphs) were refreshed in the excel.
After upgrading to office 2007 the hyperlinks from the excel to the word
document do not update.






All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com