We have two homes and I have a computer at both homes. I had them set up
fairly identically.

(Among others) I have several Excel files that I have been keeping synchronized
on two different machines (in two different locations) by carrying the data
files back and forth. This has worked reasonably well to date.

Given the amount of data, and the broadband speed available to me,
synchronization over the Internet would not be practical.

Since the Data storage folder structure was the same, it was trivial to run the
worksheets on either computer.

However, I have recently had to upgrade one of the computers to Windows 7. So
the data storage folder structure is different. For example, a file at:

C:\Documents and Settings\Ron\My Documents\DATA\EHC\Investment Committee

is now stored, on one machine only, at something like

C:\Users\Ron\......

(Non-Microsoft) Add-ins are also stored in different places on the two
machines.

The consequences are that the Add-ins don't load; and the links within some of
the worksheets don't point to the correct location, depending on where the file
was last saved.

I am trying to decide the best way to deal with this.

My first thought, with regard to the links within the worksheets, was to

1. Save the "Computer Saved On" in the document properties section of the
workbook.

2. If the "Computer Saved On" doesn't match the current computer, then update
the links within the workbook on the File Open event.

My second thought would be to somehow restructure the data folders so that they
are "NAME'd" the same on the two machines. That would be tedious, but doable.

I'm not sure what to do with the personal add-ins, and other add-ins (like
morefunc and others) that vary in location between the two machines. One
thought would be to move them all to a commonly named location, such as
C:\PersonalAddIns\. But I would be open to other thoughts.

Another possibility would be to test and change them from personal.xlsm (which
I do not ordinarily use).

In any event, I'm sure others have dealt with this issue in the past, and I
would be grateful for suggestions.

Thanks.
--ron