Excel links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete - 25 Oct 2005 14:44 GMT

I want to make sure that if I send out a spreadsheet with a linked
spreadsheet, that the people I send this to will not be able to open or
display the linked infomation. Does excel make sure that this
infomation cannot be displayed?

Reply to this Message

Bill Manville - 25 Oct 2005 23:06 GMT

> I want to make sure that if I send out a spreadsheet with a linked
> spreadsheet, that the people I send this to will not be able to open or
> display the linked infomation. Does excel make sure that this
> infomation cannot be displayed?

If the source file (to which your spreadsheet is linked) is not visible
to the people receiving it (e.g. on the same network) then they will not
be able to open it.

They will normally be able to see the values that your formulas have
extracted from that source workbook. You can reduce the visibility by
hiding the worksheets containing the formulas and password protecting the
workbook structure and/or by setting the formulas to be locked and hidden
(Format / Cells / Protection) and password protecting the worksheets.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

Nan - 26 Oct 2005 01:21 GMT

I really hate to sound like an nut case but ... I want to post a question to
this group. When I try to post I am asked to choose a discussion group.
What group is this?

> > I want to make sure that if I send out a spreadsheet with a linked
> > spreadsheet, that the people I send this to will not be able to open or
[quoted text clipped - 14 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message

Bill Manville - 26 Oct 2005 20:21 GMT

microsoft.public.excel.links

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message