Updating excel/word links.

[xoggoth]

My accounts are in Word document with numerous links to an Excel sheet that takes all the necessary info from other accounts sheets.

Am updating all my accounts to Office 2007 so the sheet will be .xlsx instead of .xls, also due to more rows/columns, saving as an .xlsx sheet has gone and renamed all my names for link cells from LABnnn to _LABnnn.

Suppose I will have to set up all the links again individually, UNLESS some CUK genius knows a quicker way? Cheers.

[Spacecadet]

2007 word and excel docs are zipped containers. The meat of the document will be contained in an XML document.
Change the file name from xoggoth.xlsx to xoggoth.zip and you can poke around inside, this might give you a quicker method to mass update lots of links.

Make sure you back up first

[xoggoth]

Hey, they do open as zip and found all the link files. Whoda thought of renaming to zip? Cheers Spacecadet.

PS Could have sworn I replied earlier. Probably stuck it on some other post at random as usual. Why be boring?