#1
|
|||
|
|||
Joining two (or more) spreadsheets without use of a 'ghost'
Morning All
I have several Excel 2013 spreadsheets which I need to keep separate. however I wish to cross-reference between them. This is clearly not a problem. Excel is happy to do this. But only provided I keep them on the same computer/server. If I download the spreadsheets to a stick or email them the link is lost. For example: I have an accounting spreadsheet (Accounts) and a contacts spreadsheet (Contacts). When entering the contact reference number is entered in Accounts it populates fields using IndexMatchMatch from Contacts. It does this on the original computer (obviously!), but on the downloaded version Accounts tries to find Contacts by referring back to the original spreadsheet. Although it behaves as if it is linked it is not because if I alter details on Contacts there is no effect in the Accounts. It is as though Accounts carries a ghost version of Contacts with it. There is no linking back from Accounts to Contacts. What I want to do is make them joined/linked/whatever so they act as one when downloaded or emailed. I do not want to add Contacts as a tab on Accounts. Any ideas? Richard |
#2
|
|||
|
|||
If I am understanding you correctly, you need to refresh the links in the referencing workbook. This is done under the File menu heading. The interface for this, at least in Powerpoint 2010 (where I use it frequently) is a kludge and in dire need of an overhaul by Microsoft.
|
#3
|
|||
|
|||
Thanks, Gebobs, However I think I have managed to solve the problem. The entire folder containing the two or more linked workbooks must be in the same folder and the entire folder must be copied/emailed(after zipping). Otherwise the workbook will continue to look for the original link. If it is not there the workbook carries with it a ghost version of the link,
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ghost text | yachts66 | Word | 1 | 01-26-2015 03:36 AM |
Ghost text box | dmg1969 | Outlook | 7 | 03-24-2014 10:53 AM |
what is this ghost dupe of a Word doc | ldimitroff | Word | 3 | 02-05-2013 03:09 PM |
Ghost Text | scott_j_g | Word | 4 | 05-12-2011 01:19 AM |
word 2003 - letters joining together - please help | katiesm | Word | 1 | 11-24-2009 02:20 PM |