Synchronize linked workbooks?

[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

 

[Jonathan Rynd]

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

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.

 

[Debbi Hjelle]

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

 

[Jake Klenow]

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.

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