Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2015, 03:56 AM
Richard121 Richard121 is offline Joining two (or more) spreadsheets without use of a 'ghost' Windows 7 64bit Joining two (or more) spreadsheets without use of a 'ghost' Office 2013
Novice
Joining two (or more) spreadsheets without use of a 'ghost'
 
Join Date: Feb 2015
Posts: 10
Richard121 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-11-2015, 06:29 AM
gebobs gebobs is offline Joining two (or more) spreadsheets without use of a 'ghost' Windows 7 64bit Joining two (or more) spreadsheets without use of a 'ghost' Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 02-16-2015, 01:38 PM
Richard121 Richard121 is offline Joining two (or more) spreadsheets without use of a 'ghost' Windows 7 64bit Joining two (or more) spreadsheets without use of a 'ghost' Office 2013
Novice
Joining two (or more) spreadsheets without use of a 'ghost'
 
Join Date: Feb 2015
Posts: 10
Richard121 is on a distinguished road
Default

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,
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Joining two (or more) spreadsheets without use of a 'ghost' Ghost text yachts66 Word 1 01-26-2015 03:36 AM
Ghost text box dmg1969 Outlook 7 03-24-2014 10:53 AM
Joining two (or more) spreadsheets without use of a 'ghost' what is this ghost dupe of a Word doc ldimitroff Word 3 02-05-2013 03:09 PM
Joining two (or more) spreadsheets without use of a 'ghost' Ghost Text scott_j_g Word 4 05-12-2011 01:19 AM
Joining two (or more) spreadsheets without use of a 'ghost' word 2003 - letters joining together - please help katiesm Word 1 11-24-2009 02:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft