Excel links (changing names & moving folders)

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Excel training course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · High Priority · Version Standard

Nick has attended:
Access Introduction course

by - delegate Nick bronze contributer [28 posts] (2008 Apr 1 Tue, 11:00) Reply

Losing links when Changing spreasheet names :
I have several spreeadhseets that are linked together - I want to change the name of the spreadsheets however when i do I lose the links between the various spreadsheets - is it possible to change the name of linked spreadhseets without losing the links and having to manually update the links??

Losing links when Moving folders :
Also, it is possible to copy a folder of spreadsheets to another folder, rename the spreadsheets in the new folder and have the links automatically update (I have tried and have the same issue, when I move the spreadsheets the links still point to the original folder and file name)

Thanks
NICK

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel links (changing names & moving folders)

by - trainer Amanda diamond contributer [1217 posts] (2008 Apr 11 Fri, 16:49) Reply

Hi Nick

Thank you for your question.

I think once a link is set up and something changes (filename or location of file) you will need to fix the link.

Amanda

· Reporting and Analysis with Excel
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Crazy Things People Have Done With Excel
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips