A Completely Linked Copy of a Workbook

[gimmyd]

I'm wondering if there is an easy way to save a duplicate workbook so that all the information is automatically linked to the original so updating to the original will automatically take place in the copy.

 

[xlbo]

Surely, just saving it as a different name will keep all links ??
Geoff

 

[gimmyd]

I don't think I was clear. The original has no links at all. I want the copy to be linked to all cells in the original and stay synchronized with it. Thanks.

 

[Hasit]

Theres no way I am aware of that will do this for you .

You can create a reference to the file (in the new one) and then drag the cell to all other cells, which should create the links for you. Then save the new file.

 

[xlbo]

The easiest way I can think of is to use the Before_Save event.
use
Activeworkbook.saveas Filename:="YourFilePathandNameGoHere"

in there - whenever the wb is saved, this'll save a copy - if no save is made, no data is changed therefore no need to save a copy.

HTH
Geoff

 

[SkipVought]

Hey gimmyd,

Why?

Why are you wanting a linked workbook?
What is the reason?
What is the business case?
Skip,
metzgsk@voughtaircraft.com

 

[gimmyd]

I use a set of spreadsheets that track survey scores and tabulations with a variety of links and formulas. The information is to be shared on the network but it is not readily apparent who will need the information so I can't set up password access. I wanted the workbook to be immediately updated by me but with the users unable to change my data and circulate it without my being aware.