If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2003 update link when Source open
I have a similar problem. We have a procedure which opens a (multiple sheet)
Excel workbook, then open a Word document with links to the workbook. We rename the Excel file (also into a different directory) and the links in the Word file automatically update to the new path. This works perfectly with Office 95 but when using Office 2003, ONLY THE CURRENT (displayed) SHEET of the Excel workbook is updated (path & filename) in the Word links - all the other sheets still point towards the old path. "tim" wrote: Dave, Thanks for the suggestion, this had no apparent effect. The issue(s) is still not resolved. Tim "Dave Peterson" wrote: This is a guess (I don't use xl2003 and I don't have a network to try it on.) Try tools|options|General Tab|Web options button|Files tab Uncheck "update links on save" Can you post back with the results of your testing? tim wrote: Hi, I recently migrated to 2003 and when using a file created in 2002 the links do not update when the Source file is open. First, I opent the destination workbook, choose not to update links, open the source workbook and make changes. The changes are not updated in the destination workbook. If I edit the equation in the destination workbook by deleting the path ('\\server\folder\[filename]sheet'!cellref) up to the filename of the source, then the values update. Once I close the source, the equation in the destination changes to a mapped drive type path ('S:\folder\[filename]sheet'!cellref). Why are the links not updating when the source is open, and why is the path changing from \\server style to mapped drive style? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
merging Word 2000 data source and word 2003 envelopes | Jini | Mailmerge | 1 | December 2nd, 2004 10:48 PM |
how come I can't update office 2003 | pghsteelersfan | Powerpoint | 2 | September 9th, 2004 02:11 AM |
HOw to tie an update query to on open of a report | Barb | Setting Up & Running Reports | 1 | September 8th, 2004 11:42 AM |
MailMerge cannot open Access QUERY data source | Chuck Hartman | Mailmerge | 3 | June 3rd, 2004 01:00 PM |
Publisher 2003 hotfix package Update (KB 838901) | Brian Kvalheim - [MSFT MVP] | Publisher | 0 | May 7th, 2004 08:38 PM |