excel links

  • Thread starter Editing multiple links from excel
  • Start date
E

Editing multiple links from excel

I have a word document with 40-50 links to excel. Each quarter I have to
edit the links one at a time to change the item reference from Q3 to Q4
(separate worksheets in my excel file). Is there a way to do this other than
one at a time?
 
M

macropod

Hi,

Which version of Word? In what format are the links?

Have you thought of linking to generic Excel file (eg named 'Last Quarter'), then simply copying your quarterly files over that
periodically? That way there's be no link updates needed. This could also be useful if you needed to redo the report for some other
previous quarter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update source file for all links at once 4
In Word2007 links to excel do not automatially updae 7
Word2003 changing multiple linked source files at once 1
How do I view and/or delete links in a Word document? 3
Edit Links/Change Source 1
Open Word 2007 doc with link to Excel 2007 4
Update a number of links automatically 3
Problem with links 1

Top