Synchronize linked workbooks?

  • Thread starter Thread starter Debbi Hjelle
  • Start date Start date
D

Debbi Hjelle

I have a pocket PC that synchronizes files "both ways" --
that is, if I have updated an Excel file on the pocket PC,
the matching file on my desktop computer is updated -- and
vice versa.

Is there anyway to accomplish the same thing between two
Excel files -- for example, one on my hard drive and one
on a network?

I have tried linking the two (hard drive="source";
network="destination") -- using the link formulas -- but
have encountered some difficulties.

It seems to me that if a synchronizing software can update
files between my pocket PC and someplace else, it should
be a simple thing to synchronize two files between a hard
drive and a network.

Thanks in advance.

Debbi
 
Is there anyway to accomplish the same thing between two
Excel files -- for example, one on my hard drive and one
on a network?
Click to expand...

What level of synchronization do you want?

If you will only make changes on one of the instances of the file, then
synchronize, then something as simple as Microsoft's Briefcase (comes with
the operating system--check Help), or VU-Software's VuBrief (
http://www.vu-brief.spb.ru/eng/ ) will work.
 
Many thanks! It works beautifully.

In looking at Windows Help for Microsoft Briefcase, I also
discovered information regarding Offline Files and
Synchronization Manager. For now, I'll use Briefcase, as
it seems simpler than some of the other options (with less
possibility for user error?). Eventually, I'll compare
and contrast the other options as well.

Again, thanks.
Debbi
 
Debbi Hjelle said:
Many thanks! It works beautifully.

In looking at Windows Help for Microsoft Briefcase, I also
discovered information regarding Offline Files and
Synchronization Manager. For now, I'll use Briefcase, as
it seems simpler than some of the other options (with less
possibility for user error?). Eventually, I'll compare
and contrast the other options as well.
Click to expand...

For what it's worth, I have used both and do find that Briefcase is better
in the long-run for simple operations.
 
Back
Top