Help Appreciated,

- spreadsheet was created on the network and linked to other files on the
network

- I duplicated a tab and deleted data (on the duplicated tab) that I did
not want visable

- duplicated spreadsheet was moved to a separate file and subsequently to
local drive and then emailed to another user with no access to the network

- when the user received the file and copied formula's down the worksheet,
the file attempted to link to the network but could not find file

- the user then clicked "Cancel" & F9 to calc. Data populated as if
connected to the file on the network

The only thing I can think of is there is some sort of hidden data in the
file ?

The solution is to break the links but this is scary when dealing with
confidential information.

Is there anything else I can do, other than break links?

Thx in advance,