Keep workbooks linked when the path changes XL2003

twistedoctor

New Member
Joined
Apr 1, 2011
Messages
2
I have two workbooks.

Workbook A contains four spreadsheets (of various customer data).

Workbook B uses formulas and queries to import the data from Workbook A.

I have to email, or upload both of these workbooks to a customer so they can continue to update the data in Workbook A, and "refresh" the links to update Workbook B.

How do I email, or upload, both of the workbooks so that the customer does not have to rename every path in Workbook B to see Workbook A? Is this even possible?

Example:
Workbook A & B have been downloaded to a new computer. Both are saved in a file on the desktop together. I open Workbook A, no problems. I open Workbook B, and I get a message "Data connections have been disabled". I click to enable the content and I receive this message:

'C:DOCUMENTS AND SETTINGS\JSTRAHAN\DESKTOP/WorkbookA.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

:( Easy fix, right?...
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

CWatts

Well-known Member
Joined
Jan 22, 2010
Messages
701
When working with linked files, I've had success keeping them in the same directory.and emailing them within a ZIP file. I then would tell my recipient to extract them to the same folder and they should work, otherwise, I'd suggest they open the source file first, and then the file that references to the source file second so they find each other.

If they are currently not in the same directory, opening both and using Save As... should reset all the links without headache.
 

twistedoctor

New Member
Joined
Apr 1, 2011
Messages
2
I had the client try opening the source first, then the spreadsheets (and they are saved in the same folder) but that did not work. Neither did having her do a SAVE AS. Instead of looking in the same folder for the source, the path keeps directing it back to my computer - which of course is invalid. Anything else I could try?
 

Watch MrExcel Video

Forum statistics

Threads
1,089,992
Messages
5,411,712
Members
403,392
Latest member
Faster 72

This Week's Hot Topics

Top