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
|
|||
|
|||
Faulty Links
Hello
I have several spreadsheets setup and they have links to other spreadsheets picking up values etc. All of these spreadsheets are on the same drive. I went on holiday for a couple of days, come back and all the links are incorrect. Where(for example)one was ='[Independant data.xls]Token'!$G$116 It is now =+'C\Programme Files\Microsoft Office\Office\XLStart\(Then the path from the first folder on the correct drive to the Spreadsheet) It has changed nearly all of the links and when you double click in the Cell it usually takes you to the spreadsheet it gets the data from but now it just brings up an error. Nobody has changed anything (so they say!) Any ideas what may have caused this and how it can be fixed on a whole rather than one by one? Thanks |
#2
|
|||
|
|||
Faulty Links
Rich wrote:
Any ideas what may have caused this No and how it can be fixed on a whole rather than one by one? Edit / Links / Change Source Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Quick links for Office 2003 | djohnson | Setup, Installing & Configuration | 1 | April 29th, 2004 10:36 PM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Deleting links | Frank Kabel | Worksheet Functions | 4 | February 24th, 2004 06:45 AM |
Automatic Links in Excel 2003 | Nick Hodge | Links and Linking | 4 | December 18th, 2003 02:06 PM |
Links | Paul W Smith | Links and Linking | 3 | October 16th, 2003 02:28 PM |