| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Field link to a hidden cell in Excel
I have made a word document that gathers information from an Excel sheet
trough field links (copy and paste special). I also use a macro to update the links automatically. In the excel sheet I want to hide some of the cells that I have linked to, but when I hide the cells in excel the information disappears from the word document. Does anybody know how I can work around this problem? Ronny |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Field link to a hidden cell in Excel
If the update method for the links is set to lock you can achieve what you
want, however, you will have to manually update the links if set to lock. "Ronny" wrote: I have made a word document that gathers information from an Excel sheet trough field links (copy and paste special). I also use a macro to update the links automatically. In the excel sheet I want to hide some of the cells that I have linked to, but when I hide the cells in excel the information disappears from the word document. Does anybody know how I can work around this problem? Ronny |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Field link to a hidden cell in Excel
Thanks for the answer, but that wont work for me. The word document must be
updated automatically, and the cells in Excel must be hidden all the time. "PJY" wrote: If the update method for the links is set to lock you can achieve what you want, however, you will have to manually update the links if set to lock. "Ronny" wrote: I have made a word document that gathers information from an Excel sheet trough field links (copy and paste special). I also use a macro to update the links automatically. In the excel sheet I want to hide some of the cells that I have linked to, but when I hide the cells in excel the information disappears from the word document. Does anybody know how I can work around this problem? Ronny |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link a document field to a table cell? | Tables | |||
| Link a word drop down field "text" to an excel cell | Microsoft Word Help | |||
| LINK field in Word - Pasting from Excel | Microsoft Word Help | |||
| Paste a range of Excel cells into Word as a link, cell outlines vi | Page Layout | |||
| How to link a word field to an excel spreadsheet | Microsoft Word Help | |||
Linear Mode
