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?...
 

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?
 

Forum statistics

Threads
1,084,752
Messages
5,379,650
Members
401,619
Latest member
manpais

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top