Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 01-07-2011, 05:59 AM
iffy iffy is offline Windows XP Office 2003
Join Date: Jan 2011
Posts: 8
iffy is on a distinguished road
Default Relinking excel worksheets

I created a few worksheets with simple formulas in it. The worksheets populated another worksheet with its values. Now this worksheet has been working fine with no issues, but I recently moved the sheets from one system to another and due to this, Im getting all funny errors. Basically the sheet that is dependant on other sheets is not updating with values properly. So what do I do? Please help!
Reply With Quote
Old 01-07-2011, 06:48 AM
Nirik's Avatar
Nirik Nirik is offline Windows XP Office 2007
Smart Novice
Join Date: Dec 2010
Location: Mumbai, India
Posts: 24
Nirik is on a distinguished road
Default Difference in link location and actual location of file

As you have moved the file from one system to another, there might be possibility that the location which you have chosen in the old system will be different from the location in the new system (e.g while writing the formula in the file (old system) for instance the location of the file is destop & now (new system) the location of the same file will somewhere else rather than destop. Another possiblity may be that the user which was there in old system & in the new system may be different. ( e.g user name in old system xxxx & in new system zzzzz). see this if u still face the problem the let me know.

Last edited by Nirik; 01-07-2011 at 07:10 AM. Reason: Spelling Mistake
Reply With Quote
Old 01-07-2011, 01:53 PM
macropod's Avatar
macropod macropod is online now Windows 7 32bit Office 2000
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,177
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all

Hi iffy,

For your links to work, the shortest relative path between the two files must be the same. For example, if the source file's path on the old system was:
C:\Users\Iffy\Documents\Work\Property\Plans\Source File.xls
and the target file's path on the old system was:
C:\Users\Iffy\Documents\Work\Property\Services\Coo ling\Target File.xls
then the shortest path from the target file to the source file was from Services\Cooling to Plans.
On the new system, provided the same arrangement exists, the links should work. If you don't have that, you'll need to update the links. Ordinarily, I would expect the target file to alert you if it could not locate the source file.
Paul Edstein
[MS MVP - Word]
Reply With Quote
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't save worksheets anymore Lesq Excel 0 07-21-2010 08:43 AM
Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM
Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Linking text between worksheets AndrewsGram Excel 1 03-09-2010 01:26 PM
Help with worksheets on Word eballi Word 6 11-18-2009 05:17 AM

All times are GMT -7. The time now is 01:16 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft